what is the logic will you implement to load data into a
fact table from n dimension tables?
Answer Posted / elango
fact table should contain all foreign key (PK) of the
dimensional tables, and it should be measured based on the
measures in the fact table as per the client specification.
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is the difference between router and filter?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What is the need for an etl tool?
Separate from a database, an information bazaar, and an information stockroom?
What is informatica etl tool?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
Describe the impact of several join conditions and join order in a joiner transformation?
What is meant by pre and post session shell command?
How to create or import flat file definition in to the warehouse designer?
Explain incremental aggregation in informatica
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
How to open an older version of an object in the workspace?
4 yrs etl devloper roles and responsibilities?any body give solutions
What if the source is a flat-file?
What is the use of transformation?