Add a Lookup transformation to retrieve data based on a specified lookup condition. When you add a Lookup transformation to a mapping, you define the lookup connection, lookup objects, and lookup properties related to Snowflake.
You can look up Snowflake data values based on a condition that you configure. In the Lookup transformation, select the lookup connection and object. Then, define the lookup condition and the outcome for multiple matches.
The mapping queries the lookup source based on the lookup fields and the defined lookup condition. The lookup operation returns the result to the Lookup transformation, which then passes the results downstream.
You can also set the default column value for the return field in a cached Lookup transformation in a Snowflake mapping. However, in advanced mode, you can't set the default column value for the return field.
You can configure the following lookups:
•Connected. You can use a cached or uncached connected lookup for mappings. You can also use a dynamic lookup cache to keep the lookup cache synchronized with the target.
•Unconnected. You can use a cached lookup. You need to supply input values for an unconnected Lookup transformation from a :LKP expression in a transformation that uses an Expression transformation.
Note: In advanced mode, cached and uncached lookups are not applicable.
For more information about Lookup transformation, see Transformations in the Data Integration documentation.