Warehouse DataStage Question:
Download Job Interview Questions and Answers PDF
Explain What is the flow of loading data into fact & dimensional tables?
Answer:
Here is the sequence of loading a datawarehouse.
1. The source data is first loading into the staging area, where data cleansing takes place.
2. The data from staging area is then loaded into dimensions/lookups.
3.Finally the Fact tables are loaded from the corresponding source tables from the staging area.
1. The source data is first loading into the staging area, where data cleansing takes place.
2. The data from staging area is then loaded into dimensions/lookups.
3.Finally the Fact tables are loaded from the corresponding source tables from the staging area.
Download Warehouse DataStage Interview Questions And Answers
PDF