Add transformations to the mapping to represent the operations that you want to perform on data.
You can add the following transformations and define the transformation details in a mapping:
Source transformation
Add a Source transformation to read data from Snowflake or other data sources. You can read from a single or from multiple Snowflake tables. You can also use a query or parameter as the source type to read from Snowflake.
You can use one or more Source transformations in a mapping. When you use a single transformation to read from multiple tables, you can use a join. If you use two Source transformations in a mapping, use a Joiner transformation to join the data.
Target transformation
Add a Target transformation to write data to Snowflake. You can use one or more Target transformations in a mapping. When you configure a target transformation, you an use a single Snowflake target object. You can use a new or an existing Snowflake target object. You can also use parameters to define the target connection and target object when you run the mapping task.
Lookup transformation
Add a Lookup transformation to retrieve data based on a specified lookup condition. The lookup object can be a single object or query. You can also parameterize the lookup objects and connections.
For more information about the objects and the properties that you can configure for each of these transformations in a mapping