What's lookup and joiner transformation?

Question

Accepted Answer

Lookup and Joiner are two types of transformations used in ETL process.

Lookup transformation is used to look up data from a source based on a key and return the corresponding data.
Joiner transformation is used to join data from two or more sources based on a common key.
Lookup transformation can be used for both connected and unconnected lookup.
Joiner transformation can be used for inner, outer, left outer, and right outer joins.
Lookup transformation can improve performance by caching frequently used data.
Joiner transformation can be used to combine data from different sources, such as a customer table and an order table.