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
How to generate sequence numbers using expression transformation?
Mention few power centre client applications with their basic purpose?
What do you mean incremental aggregation?
How to update or delete the rows in a target, which do not have key fields?
What are the advantages of using informatica as an etl tool over teradata?
What is the Rank index port in Rank transformation?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
tell me about your project functionality
can we override a native sql query within informatica? How do we do it?
What's the layout of parameter file (what does a parameter file contain?)?
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
How many ways are there to create ports?
What is the way to execute pl/sql script using informatica mapping?
What is meant by target load plan?
Please let me know how to make encryption and decryption with example?