What is a difference between joiner and lookup transformation?

Nilesh Aher
Nilesh Aher

Posted On: Dec 31, 2020


    1 Answer Written

  •  Nilesh Aher
    Answered by devquora

    Both joiner and lookup transformations are used in data integration and ETL (Extract, Transform, Load) processes in data warehousing. However, some of the major key differences are as follows:

    Functionality: The joiner transformation is used to combine data from two or more sources based on a common key. It performs a join operation similar to what is done in SQL. The lookup transformation, on the other hand, is used to look up a value from a reference table or file based on a key value in the input data.

    Performance: Joiner transformations can be more resource-intensive, especially when dealing with large datasets. This is because they require sorting and merging of data from multiple sources. Lookup transformations, on the other hand, can be more efficient as they typically involve only a single table or file lookup.

    Usage: Joiner transformations are typically used when you need to combine data from multiple sources into a single dataset. This might be necessary, for example, when you need to combine sales data from a POS (Point of Sale) system with customer data from a CRM (Customer Relationship Management) system. Lookup transformations, on the other hand, are useful when you need to enrich or supplement data with additional information from a reference table or file. For example, you might use a lookup transformation to add product descriptions or prices to an existing sales dataset.

    In summary, while both joiner and lookup transformations are used to integrate data in ETL processes, the main difference lies in their functionality and usage.

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...