What is the difference between lookup override and souce
qualifier override ?

Answers were Sorted based on User's Feedback



What is the difference between lookup override and souce qualifier override ?..

Answer / kunal

1) SQ Override- In case of SQ override the unwanted columns
are filtered out and the required columns based on some
filter condition returned as an input to the next
transformation.
LKP Override- In case of LKP override, look up conditions
are checked and the records passed to next
transformation.Look up override can be applied on source or
target table.
2) In case of SQ override user has to mention order by
clause when required.
In LKP override the look up trans. internally apply order
by clause and if user want to use order by clause, user has
to mark '--' to disable the lkp order by clause.

Is This Answer Correct ?    13 Yes 1 No

What is the difference between lookup override and souce qualifier override ?..

Answer / siddardh

Both are same, which means you are writing the query which
will override informatcica generated query.

Is This Answer Correct ?    1 Yes 11 No

Post New Answer

More Informatica Interview Questions

How do you convert single row from source into three rows into target?

0 Answers  


How do you remove duplicate records in informatica? And how many ways are there to do it?

0 Answers  


From where we can start or use pmcmd?

3 Answers  


On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?

6 Answers  


In which situation we will use persistant cache and shared cache in real time. plzsss answer with example

1 Answers   Wipro,






hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks... Send me----: raghukrams@yahoo.com

0 Answers  


how will you get 21 to 30 record from 50 records?

6 Answers  


to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?

3 Answers   IBM,


How to load only the first and last record of a flat file into the target?

3 Answers   Mind Tree,


what is normalization? explain 1st NF, 2nd NF, 3rd NF

1 Answers   SunGard,


My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,


What is confirmed fact in dataware housing?

2 Answers   Hewitt, TCS,


Categories