| |
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? |
| December 12, 2008 07:07:26 |
#2 |
| tisha24 |
Member Since: September 2008 Total Comments: 10 |
RE: Extract / Transform Process
|
Extraction means getting data from different/single source and loading into the staging database, in other words brining the data from different sources (like databases or flat diles) into the datastage(or any ETL tool) for further processing.
In the extraction we will ensure the nullability and cleansing the data.
Transformation: where we have to implement the following:
1.the business logics to the necessary fields,
2.populate the primary and foreign keys,
3.aggrecation of data.
4.Data conversion if necessary
5.implmentation of SCD's
|
| |
Back To Question | |
