Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is the flow of loading data into fact & dimensional tables?

April 26, 2017Data dimensional fact flow loading tables

0

Posted

What is the flow of loading data into fact & dimensional tables?

1 Answer

0

Posted

Fact table – Table with Collection of Foreign Keys corresponding to the Primary Keysin Dimensional table. Consists of fields with numeric values.Dimension table – Table with Unique Primary Key.Load – Data should be first loaded into dimensional table. Based on the primary keyvalues in dimensional table, then data should be loaded into Fact table.