Data Integration Solution Architect / Data Architect

Looking for challenges. Contact me on Linkedin.

Data Warehouse Objects Loading Order

On

Data Warehouse Objects Loading Order

By Mindaugas Lukošius

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