Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance
issue. how to fix the performnce issue of the query.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Informatica Interview Questions

What is meant by incremental aggregation?

0 Answers  


what is work of PUSH DOWN option

2 Answers   Wipro,


What is A cache?

2 Answers  


What is the main difference between a Joiner Transformation and Union Transformation?

5 Answers  


I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 Answers  






what are the output files that the informatica server creats during running a session?

2 Answers   CTS,


Explain sessions. Explain how batches are used to combine executions?

0 Answers  


Can you use one mapping to populate two tables in different schemas

2 Answers  


To import the flat file definition into the designer where should the flat file be placed?

0 Answers   Informatica,


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

0 Answers   Infotech,


Hi, I am new to Informatica, What is a flat file and how to use flat file in infomratica please help me.

10 Answers   CSC,


How to load the data from a flat file into the target where the source flat file name changes daily?

0 Answers   Informatica,


Categories