Performance tuning( what you did in performance tuning)


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

Post New Answer

More Informatica Interview Questions

what is the use of Data Mart?

5 Answers   IBM,


How Union Transformation is an Active Trans?

6 Answers  


What is sorter transformation?

0 Answers  


i have two source data there is no pk,fk how to join the two sources

5 Answers   TetraSoft,


I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers   Cap Gemini, IBM,


i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  


Name the different lookup cache(s)?

0 Answers  


When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?

5 Answers  


3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?

7 Answers   TCS,


which is better perfomancewise lookup or joiner and why?can anyone give example?

6 Answers   TCS,


What is a diff between joiner and lookup transformation

16 Answers   CTS, Satyam, TCS, UHG,


What is lookup change?

0 Answers  


Categories