4 ms·
I am not a big fan for the term ELT Just because you are using a database as your work space doesnt mean you Load your data before transformation Most complex
by systems 7y ago
I am not a big fan for the term ELT
Just because you are using a database as your work space
doesnt mean you Load your data before transformation
Most complex dw, have multiple layers of transformation, and several workspaces along the way
There is always a final step where you load the clean data, into your clean schema, used for querying the data
ETL
Extract = Fetch the data you want
T = Make all necessary change
L = Create a clean copy
- ewngzen 7y agoMultiple layers, You have: 1. The raw data layer where data comes directly from buisiness log 2. Common data layer where one copy of data serves multiple purposes 3. Application layer where final result is presented
- tomnipotent 7y agoETL can include the destruction of raw data between the T & L. ELT assumes it is retained. This is a legacy from days when storage was expensive and it often wasn't tenable to retain everything.
- unityByFreedom 7y agoWe held onto middle data when I worked in ETL 15 years ago. It's normal to save data in the middle for unit testing and lookup tables. I agree with GP this doesn't need a new term.