Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste

1 Answers   TCS,


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  


Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....

1 Answers  


Why use shortcuts(Instead of making copies).

1 Answers  


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

0 Answers  


What are the different versions of informatica?

0 Answers  


What are the conditions needed to improve the performance of informatica aggregator transformation?

0 Answers  


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

1 Answers   SunGard,


whether Sequence generater T/r uses Caches? then what type of Cache it is

7 Answers   Accenture,


what is the difference between Informatica 7.1 and Abinitio?

1 Answers   TCS,


Design time, run time. If you don't create parameter what will happen

0 Answers  


How can yoU create or import flat file definition in to the warehouse designer?

2 Answers  


Categories