| |
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? |
| May 05, 2009 00:53:07 |
#3 |
| smsreddy |
Member Since: May 2009 Total Comments: 5 |
RE: Extract / Transform Process
|
Generally this is going to be 2 stage process, some times 3 stage depends on the requirement.
Most of the time its 2 stage process. In first phase is to extract data from different source systems for eg : Oracle, Flat Files, SAP etc. and load into Stage area as it is and in 2nd stage apply transformation/business rules and load from Stage area to Datawarehouse/mart. |
| |
Back To Question | |
