Lookup transformation, one condition is having SQL override
(Empno < 10) and the other condition is Lookup (Sal>1000),
which is dynamic. How will u resolve this situation?


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

Post New Answer

More Informatica Interview Questions

why we need informatica

2 Answers   HCL,


can u apply SCD2 on flat file tgt? if yes wat is the procedure?

3 Answers   Deloitte,


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

2 Answers  


What is meant by query override?

0 Answers  


how i will stop my workflow after 10 errors

2 Answers   HP,






Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?

1 Answers  


How does a rank transform differ from aggregator transform functions max and min?

0 Answers  


if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups what is the o/p in the target

5 Answers   TCS,


Informatica settings are available in which file?

0 Answers   Informatica,


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

0 Answers   IBM,


Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

7 Answers   Tech Mahindra,


Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 Answers  


Categories