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

how to create user defined function (udf) in informatica

781


What is an unconnected transformation?

659


What is the fact table?

584


what is SDLC way of code development?

1555


Explain the shared cache and re-cache?

608






What do you understand by term role-playing dimension?

568


What is the way to execute pl/sql script using informatica mapping?

960


Could you explain what is enterprise data warehouse?

551


Describe an informatica powercenter?

602


Performance tuning in UNIX for informatica mappings?

2133


Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

1647


Parameter and variable differences

1613


is it possible to index the data in cache of lkp transformation ?

1520


How do you load unique records into one target table and duplicate records into a different target table?

703


Can we create multiple integration service on single repository?

695