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

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

0 Answers  


What are the Differences between static cache and dynamic cache?

1 Answers  


If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

2 Answers  


What is partioning?how many types of partinings are there

2 Answers   HCL,


Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.

0 Answers  


When to use normalization transformation other than cobol source?

2 Answers  


When do you use mapping parameters? (In which transformations)

1 Answers  


I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

8 Answers   DELL,


normalizer transformation

3 Answers   CTS,


what is shortcut in informatica? difference between shortcut,reusable object?

2 Answers   Virtusa,


without using emailtask how will send a mail from informatica?

3 Answers  


what is parameter file?

1 Answers   Cap Gemini,


Categories