| |
GeekInterview.com > Interview Questions > Data Warehousing > ETL
| Print | |
Question: Extract / Transform Process
Answer: Describe the stages of extract / transform process, including what should happen at each stage and in what order? |
| October 10, 2008 15:52:16 |
#1 |
| Mamta11 |
Member Since: July 2008 Total Comments: 12 |
RE: Extract / Transform Process
|
In the Extract process, all the data from source system (relationaltables or flat files or XML sources) is extracted and saved onto the stagging area.
All the data from Staggign area will be transformed applying the business logic.
All the transformed data will be loaded to the target. |
| |
Back To Question | |
