| |
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 13:05:26 |
#4 |
| raj_infadev |
Member Since: October 2007 Total Comments: 5 |
RE: Dimension Table Vs Fact Table
|
I think there won't be any logic difference in a mapping to load dimension table & fact table. We can load the dimension table directly but we can't load the fact table first. So, to load the fact table we need to load the dimension table first. Also while loading the fact table we will make a lookup on the dimensioin table, cause the fact table contains the measures/facts & the foreign keys which are primary keys in the dimension tables surrounded to that fact table. We can load the dimension table & fact table in one mapping by using the "Target Load Order/Target Load Plan" in informatica.
Example:
/ Target 1 (Dimension Table)
Source - Transformations -
Target 2 (Fact Table)
etc..... |
| |
Back To Question | |
