What is the sequence of activities to load data into warehouse?

Options
- First load data into fact tables then dimension tables, then Aggregates if any
- First Aggregates then load data into dimension tables, then fact tables
- First load data into dimension tables, then fact tables, then Aggregates if any
- Does not matter if we load either of fact, dimensions, or aggregates


CORRECT ANSWER : First load data into dimension tables, then fact tables, then Aggregates if any

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement