April 20, 2010 at 10:50 pm
what we do in staging area in ETL process
April 21, 2010 at 4:29 am
We stage our tables there.
The ETL proces can be divided in 3 steps:
1. Import: here you gather your data from various sources (Excel files, other databases et cetera) --> the E of ETL
2. Staging: this is a temporary area where the data of the current load resides. This data comes from the import layer after some logic, calculations et cetera --> the T of ETL
3. Loading: this loads the data of the staging area to the data warehouse, where the history is kept (if needed by your business case). Depending on the type of tables, you need to insert or update the data --> the L of ETL
In most methodologies, the staging area is an area where your data temporarily resides, meaning, you can truncate or recreate it after each run of the ETL.
Fur further research, I recommand the books written by Kimball or Imnon.
I have a question for you:
did you do some research before posting your question? I mean, seriously, just typing "ETL staging" in Google must give you tons of results.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply