When will you use SQL override in a lookup transformation?



When will you use SQL override in a lookup transformation?..

Answer / vanita

For filtering the data in lookup table using where clause, or joing multiple tables to select data or to change the default order by clause with your own order by clause

Is This Answer Correct ?    10 Yes 0 No

Post New Answer

More Informatica Interview Questions

Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com

6 Answers   HCL, Schneider,


what is mapping override?

2 Answers   Cap Gemini,


How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

3 Answers   Cap Gemini,


How many mapplets u have created? and what is the logic used

5 Answers   Mind Tree,


i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?

9 Answers   Cap Gemini,






What are the reusable transformations?

0 Answers   Informatica,


Label in Informatica. How to remove existing Label.

1 Answers   IBM, Infosys,


What are the types of groups in Router transformation?

1 Answers   Informatica,


After we make a folder shared can it be reversed?Why?

2 Answers   Accenture,


What is the filename which you need to configure in UNIX while installing infromatica?

2 Answers   Accenture,


What are the challenges you have faced in your project?

1 Answers   Cognizant, Infosys,


Can we create a Integration service without a Repository service and vice versa?

0 Answers  


Categories