Which table will load first - Fact or Dimension Table?

In Data warehouse which table will load first and why? Fact or Dimension?

Questions by Aloka   answers by Aloka

Showing Answers 1 - 6 of 6 Answers

Ram

  • Jun 30th, 2016
 

Hi Aloka,
Fact table is connect with different dimension tables with foreign key relationship. Fact table having only Ids & Measures. Dimension tables having detailed descriptions of the Ids.
Thank you !

  Was this answer useful?  Yes

Sri

  • Jul 20th, 2016
 

Dimension table will load first and then fact tables.

  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