What is a diff between joiner and lookup transformation

Answer Posted / jayash

joiner transformation does not match for null values where
as lookup transformation matches for null values
joiner transformation supports only equality operator in
condition of join where as lookup transformation can support
<=,>=,=,!= in the lookup condition

Is This Answer Correct ?    47 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of code page?

596


Write the different tools in the workflow manager?

565


update strategy transformation in informatica

628


Does an informatica transformation support only aggregate expressions?

602


Have you worked with/created Parameter file

1220






What are the main issues while working with flat files as source and as targets ?

640


Explain sessions and how many types of sessions are there?

572


How would you copy the content of one repository to another repository?

546


can anyone explain me about retail domain project in informatica?

7415


What are the main features of Oracle 8i with context to datawarehouse?

1669


How can repository reports be accessed without sql or other transformations?

714


What is the difference between source qualifier transformations source filter to filter transformation?

569


What is informatica worklet?

597


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

778


What is meant by target load plan?

547