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

define galaxy repository in informatica

1729


r u done any partitions in ur project?

1407


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

883


Which transformation should we use to normalise the COBOL and relational sources?

748


Can we override a native sql query within informatica?

632






Describe an informatica powercenter?

609


How to update source definition?

633


Write the program through which the records can be updated?

518


pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1055


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

1702


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

837


What are session parameters ? How do you set them?

1377


Reusable transformation and shortcut differences

1381


Enlist the advantages of informatica.

632


Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1562