September 12, 2013 \ Ananth TM Loading data into fact & dimensional tables 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.