Developer Mapping Guide

10.2.2
- 10.5.4
- 10.5
- 10.4.1
- 10.4.0
- 10.2.1

Back Next

Configuring a Dynamic Target

You configure a Write transformation to receive columns from the target at run time when target metadata changes. Optionally, specify a parameter as the target data object to enable the assignment of different values. You can also specify whether the Write transformation uses an associated object or a mapping flow for port definitions.

When you configure the Write transformation for a dynamic mapping, you can use one or more of the following methods:

Use a parameter as a target: Specify a parameter as the underlying data object for the target to enable you to change the schema for the Write transformation through the parameter.
Get data object columns from the target at run time: Enable the option to get data object columns from the target at run time to dynamically update Write transformation ports with changes in the target schema.
Select a target schema strategy: Select a target schema strategy to either retain the existing target schema or create or replace the target table at run time.; When you configure the Write transformation to create or replace the target, by default, the Data Integration Service drops any existing target table associated with the write object. The Data Integration Service then creates a table based on the mapping flow or data object.
If you want to customize the table or specify additional parameters such as partitions, you can define a DDL query based on which the Data Integration Service must create or replace the target table. The table contains the columns that you define in the DDL query.
Define Write transformation ports from mapping flow: When you choose to define ports from mapping flow, the Data Integration Service defines Write transformation ports based on upstream column definitions. Target columns update dynamically at run time.