| |
GeekInterview.com > Interview Questions > Data Warehousing > DataStage
| Print | |
Question: How will you determine the sequence of jobs to load into data warehouse?
Answer: First we execute the jobs that load the data into Dimension tables, then Fact tables, then load the Aggregator tables (if any). |
| November 11, 2007 20:07:09 |
#1 |
| luckyguy0007 |
Member Since: Visitor Total Comments: N/A |
RE: How will you determine the sequence of jobs to loa...
|
| The sequence of the job can also be determined by the determining the parent child relationship in the target tables to be loaded. parent table always need to be loaded before child tables. |
| |
Back To Question | |
