| |
GeekInterview.com > Interview Questions > Data Warehousing > Informatica
| Print | |
Question: Dimension Table Vs Fact Table
Answer: What is the main difference in the logic when you create a mapping for a dimension table with that of a fact table in Informatica. |
| August 08, 2008 15:27:52 |
#5 |
| hkrishnamoorthy |
Member Since: August 2008 Total Comments: 1 |
RE: Dimension Table Vs Fact Table
|
| The main difference between dimension and the fact table is that Dimension preserves the historical data (like in case of type2) we will have to use update strategy and other transformations to make that happen but fact will be a direct load with few one or more lookups from the dimension and also since the fact and dimenision has the foriegn key relationship the dimension has to be loaded first before the fact |
| |
Back To Question | |
