have u done any performance tuning? how u ll do?


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

Post New Answer

More Informatica Interview Questions

Which transformation can be created only as reusable transformation but not as non-reusable transformation?

1 Answers   Informatica,


How to use pmcmd utility command?

0 Answers  


I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

2 Answers   IBM,


By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?

8 Answers  


My questions is i create a two sessions for one mapping.but my requirement is if all number of source records are same as in target then execute first session or some rows are rejected due to t/r logic so session two was execute please clarify

1 Answers   TCS,






Explain about the concept of mapping parameters and variables ?

3 Answers   HCL, TCS,


What are the guidelines to be followed while using union transformation?

0 Answers   Informatica,


How many cubes create from a single model?

1 Answers  


tell me the informatica architecture

1 Answers   Banca Sella, Wipro,


What is joiner transformation?

0 Answers  


Without using any transformations how u can load the data into target?

15 Answers   IBM,


what is bitmap index? did u use it?and how to use it in informatica

1 Answers   IBM,


Categories