The above might rise another question: Why do we have to load the dimensional tables first, then fact tables:

As we load the dimensional tables the keys (primary) are generated and these keys (primary) are Foreign keys in Fact tables.
  • Interview Candidate
  • 3
  • 2846

Showing Answers 1 - 3 of 3 Answers

nikhilanshuman

  • Dec 17th, 2010
 

in dimensional model,fact tables are dependenet on the dimension tables.This means that fact table contains foreign keys to dimension tables.This is the reason,dimension tables are loaded first and then the fact table.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions