Answer Posted / chandrasekar
Fact tables are normalized. Dimension tables are denormalized
| Is This Answer Correct ? | 27 Yes | 0 No |
Post New Answer View All Answers
Define filter transformation?
Explain sessions. Explain how batches are used to combine executions?
Is it possible to define a single node as a Gateway node as well as worker node?
Mention some types of transformation?
What is lookup change?
What is event and what are the tasks related to it?
What are the issues you have faced in your project? How did you overcome those issues?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
What is the benefit of session partitioning?
How to load last n records of file into target table - informatica
Is it possible to create multiple domains on a single Informatica server?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
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.
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1