What is a difference between joiner and lookup transformation?
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
Subscribe Our NewsLetter
Never Miss an Articles from us.
Recent Articles
Featured Categories
- Common Interview Questions
- Python Flask Interview Questions
- NoSQL interview questions
- JQuery Interview Questions
- C programming interview questions
- AngularJS Interview Questions
- Node JS Interview Questions with Express
- JavaScript Interview Questions
- Core Java interview questions
- HTML Interview Questions
- Laravel Interview Questions
- Wordpress Interview Questions
- PHP Interview 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...