Tuesday, 8 January 2013

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

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. 

No comments: