Use the Snowflake dynamic mapping to accommodate changes to source, target, and transformation logics at run time. You can use a Snowflake dynamic mapping to manage frequent schema or metadata changes or to reuse the mapping logic for data sources with different schemas. Configure rules, parameters, and general transformation properties to create the dynamic mapping.

If the data source for a source or target changes, you can configure a mapping to dynamically get metadata changes at runtime. If a source changes, you can configure the Read transformation to accommodate changes. If a target changes, you can configure the Write transformation accommodate target changes.

You do not need to manually synchronize the data object and update each transformation before you run the mapping again. The Data Integration Service dynamically determine transformation ports, transformation logic in the ports, and the port links within the mapping.

For information about dynamic mappings, see the

Informatica Developer Mapping Guide

.

There are the two options available to enable a mapping to run dynamically. You can select one of the following options to enable dynamic mapping:

In the
Data Object
tab of the data object read or write operation, select the
At runtime, get data object columns from data source
option when you create a mapping.
When you enable the dynamic mapping using this option, you can refresh the source and target schemas at runtime.
In the
Ports
tab of the data object write operation, select the value of the
Columns defined by
property as
Mapping Flow
when you configure the data object write operation properties.