what is the -ve test case in your project.


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

Post New Answer

More Informatica Interview Questions

What are the steps involved in the migration from older version to newer version of Informatica Server?

0 Answers  


i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

2 Answers   HP,


Explain the mapping variable usage example in informatica

0 Answers   Informatica,


How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target

1 Answers  


my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same

2 Answers   KPIT,






how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

0 Answers   CTS,


In Datastage, we have row generator stage to generate dummy row. Is there any such transformation in Informatica. Thanks in advance, Kumar

1 Answers  


Filter transformation in the condition one of the data is NULL would the record be dropped.

2 Answers  


If u select groupby port in aggregator what is output and dont select groupby option what is output

2 Answers  


What is workflow variable? When we use workflow variable? Can any one explain me with one example???

2 Answers   TCS,


Explain the shared cache and re-cache?

0 Answers  


How many types of sessions are there in informatica.please explain them?

0 Answers   Informatica,


Categories