what is the logic will you implement to load data into a
fact table from n dimension tables?
Answer Posted / vikaskrmails@gmail.com
fist of all, Fact and Dimensions are separate entity tables
because fact contains measures and PK and FK where as Dim
contains Detail data along with PK and FK.
Dimensions and fact's loaded by their different sources
first we load dimensions and simultaneously assigned it to
surrogate key by sequence or CSUM etc functions. dimension
can maintain FK for other related dimensions and facts.
after loading fact we are updating it with Dim's PK-FK by
lookup.
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Target increases every day even though no new record was inserted
Can we create two repositories on same database instance in oracle?
Define enterprise data warehousing?
What are the uses of etl tools?
Explain target update override in informatica
without table how to come first record only in oracle?
How big was your fact table
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
can we override a native sql query within informatica? Where do we do it?
What is blocking transformation?
Performance tuning in UNIX for informatica mappings?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are connected or unconnected transformations?