what is the logic will you implement to load data into a
fact table from n dimension tables?
- 4 Answers
- 18079 Views
- TCS, I also Faced
- E-Mail Answers
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
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is rank transformation in informatica
Differentiate between router and filter transformation?
What is meant by lookup transformation?
What is an expression transformation?
What is the function of aggregator transformation?
Explain direct and indirect flat file loading (source file type) - informatica
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is the difference between informatics 7x and 8x and what is latest version?
can anyone suggest best free Talend data integration training online
How to call shell scripts from informatica?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
can u any challenge your project?
How do you handle two sessions in Informatica
