Menu Close

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

Leave a Reply

Your email address will not be published. Required fields are marked *