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
Whats there in global repository
Explain the tuning lookup transformation - informatica
Scheduling properties,whats the default (sequential)
How can informatica be used for an organization?
What is workflow monitor?
Explain how to import oracle sequence into informatica?
How many dimensions are there in informatica?
What is the function of look up transformation?
what are the deliverables?in your project?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Where do we use mapping variables in informatica?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is the use of transformation?
what is the -ve test case in your project.