• What is the flow of loading data into fact and 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 loaded into Fact table