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 / venkat

here lkp transformation is perform left outer join only.
it will display matching and non matching records,but in
case of non matching(while using conn lkp)records return
default value.while using unconn lkp returns null value.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain direct and indirect flat file loading (source file type) - informatica

1076


How many numbers of sessions can one group in batches?

822


What is an expression transformation?

806


What are the new features of Power Center 5.0?

1433


what are the deliverables?in your project?

1884


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

1621


4 yrs etl devloper roles and responsibilities?any body give solutions

1851


How to elaborate tracing level?

894


What is a passive transformation?

821


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

982


update strategy transformation in informatica

832


Explain load alternative records / rows into multiple targets - informatica

902


How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

885


what is $$$$?

1933


Different qualification between a related rotate toward the sky and isolates look upward?

771