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 a transaction control transformation?
Is it possible to revert a global repository to local one and why?
As union transformation gives UNION ALL output, how you will get the UNION output?
Where are the source flat files kept before running the session?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What do you mean by filter transformation?
How many numbers of sessions can one group in batches?
Is stop and abort are same in informatica?
How to update a particular record in target with out running whole workflow?
where to store informatica rejected data?
Explain the difference between mapping parameter and mapping variable?
How to Create a folder using pmrep command?
What is meant by pre and post session shell command?
difference between informatica 8.1.1 and 8.6
write a query to retrieve the latest records from the table sorted by version(scd)