Data Warehouse Objects Loading Order

Data warehouse objects must be loaded in certain order. This order could be like this:

  1. Stage or temporary tables
  2. Disable all constraints
  3. Dimension tables
  4. Fact tables
  5. Enable all constraints