Data warehouse objects must be loaded in certain order. This order could be like this: Stage or temporary tables Disable all constraints Dimension tables Fact tables Enable all constraints