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...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / cmanojkumar

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 can you define a transformation? What are different types of transformations in Informatica?

10 Answers  

Explain the difference between a data warehouse and a data mart?

0 Answers  

Is there any target staging area in informatica not staging area

0 Answers   Syntel,

hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE USING SQL T/R ?

4 Answers  

How to load data in informatica ?

0 Answers  

What is Data Caches size?

0 Answers   Informatica,

Differentiate between mapping parameter and mapping variable?

1 Answers  

Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.

1 Answers   Accenture,

What is a candidate key?

7 Answers   CTS,

How can one identify whether mapping is correct or not without connecting session?

0 Answers  

What is the diff. b/w informatica versions 8.1.1 and 8.6.1?

4 Answers   IBM, Wipro,

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

0 Answers   CTS,

For more Informatica Interview Questions Click Here
Categories