How will you determine the sequence of jobs to load into data warehouse?

First we execute the jobs that load the data into Dimension tables, then Fact tables, then load the Aggregator tables (if any).
  • Interview Candidate
  • 6
  • 5816

Showing Answers 1 - 6 of 6 Answers

luckyguy0007

  • Nov 27th, 2007
 

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions