What is a difference between joiner and lookup transformation?

Nilesh Aher
Nilesh Aher

Posted On: Dec 31, 2020


The difference between joiner and lookup transformation is as follows:

Joiner :Lookup :
A joiner is used to join data from different sources.lookup is used to get related values from another table or check for updates etc in the target table.
It supports Equiv Join only.It supports both Equiv and Non-Equiv join.
It may be we can perform outer join only.Lookup used to source as well as the target.
Joiner is used to source only.It can not perform the outer join in lookup.
It may used only the "=" operator.It may used = , < , > , <= . >= operators.
In joiner maybe not present in lookup override.It may be present in the lookup override option.
Joiner table must participate in mapping.The lookup may not participate in mapping
Joiner is used for joining two homogeneous or heterogeneous sources residing at different locations.Lookup is used to look-up the data.
Joiner is an Active Transformation.Lookup transformation is a Passive transformation.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Cognizant Informatica Interview Questions

    What is Star schema in informatica?

    Star Schema in a data warehouse, in which the center of the star can have one fact table and a number of associated dimension tables. As its structure resembles a star so it is known as a star schema....

    Cognizant Informatica Interview Questions

    What is snow flake schema ?

    In the data warehouse, Snowflake Schema is a logical arrangement of tables in a multidimensional database...

    Cognizant Informatica Interview Questions

    How do remove duplicates values in informatica from DB and Flat file?

    distinct property(keyword) is used to eliminate duplicate rows in Informatica from a database and a flat-file. We can eliminate duplicate rows from the flat-file by using group by function in an aggr...