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

Ans). Fact table – Table with Collection of Foreign Keys corresponding to the Primary Keys in 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 key values in dimensional table, the data should be laded into Fact table.

Leave a Reply