LOOKUP Condition is nothing but a Join condition?
What type of join condition it,by default ?
Using the LookUP Condition How many types of relational
conditions we can make ?

Answer Posted / vivek

as per my understanding.. lkp is always behave like left
outer join..it ll give you all matched records as well as
ummatched records which is not present in base table...and
those unmatched records is ll be null in case of
unconnected lkp trn.....

Is This Answer Correct ?    13 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to do unit testing in informatica?

729


Write the advantages of partitioning a session?

754


how to load rows into fact table in data warehouse

644


What is transformation?

663


What are some examples of informatica etl programs?

540






During the running session, output files are created by informatica server. Enlist few of them.

546


What is the difference between a repository server and a powerhouse?

820


How can we improve session performance in aggregator transformation?

678


What all are steps in up gradation of Informatica server?

624


my source is junk data how will u remove that junk data by using unix please any one replay me

3250


What are the types of caches in lookup?

578


How union transformation is used?

595


What does cheating measurement mean?

602


State the limitations where we cannot use joiner in the mapping pipeline?

553


What is depict expression change?

623