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

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).

Tags:Interview Questions, Data Warehouse, DataStage,

Please submit your Interview Answer for the above Question via replying to this post. Thank you for visiting to our blog, Have a Good Day!.

---

Sponsor Advertisement

School Management System Software

This is One of the best School management system software in the world. School Software offers complete professional institute management system administration, library, accounting, inventory, etc for all the school activities management...