Answers for Data Warehousing Online Test - Online Exam - Online Quiz - Mock Test
←Go Back to Online Practice TestQues. Sequence of jobs to load data in to warehouse |
Option 1. First load data into fact tables then dimension tables, then Aggregates if any |
Option 2. First load data into dimension tables, then fact tables, then Aggregates if any |
Option 3. First Aggregates then load data into dimension tables, then fact tables |
Option 4. Does not matter if we load either of fact, dimensions, or aggregates |
Ans. Option 2 |
Please provide the reason below. The best provided reason will be displayed with your name(if you are logged-in) on website. |
Enter Reason |
Is it helpful?
Yes
No