| |
GeekInterview.com > Interview Questions > Data Warehousing > DataStage
| Print | |
Question: What is the flow of loading data into fact & dimensional tables?
Answer: 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.
|
| May 05, 2007 08:07:57 |
#2 |
| sriram |
Member Since: Visitor Total Comments: N/A |
RE: What is the flow of loading data into fact & d...
|
When does ODS come in to picture ?
I guess its like this
_____Datawarehouse_______
l l
Source-->Stg-->ODS--l l-------->Datamart
l_____Fact________________ l |
| |
Back To Question | |
