| |
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? |
| August 08, 2009 02:20:38 |
#4 |
| sagarw9 |
Member Since: August 2009 Total Comments: 1 |
RE: Extract / Transform Process |
In the extract process, we extract the data from the different sources like data files, flat files, etc.. into the stagging area or we can say input area for the further processing. Once get files in the input, data is applied for the processing by applying some business logics to meet the requirements. After processing data, it is loaded into the target locations. |
| |
Back To Question | |