Developer Mapping Guide

10.2.1
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5
- 10.4.1
- 10.4.0
- 10.2.2

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.
Define a DDL query to create or replace the target at run time: When you choose to create or replace the target at run time, you can define a DDL query to create the target based on the query that you define. You can define a DDL query for relational and Hive targets.
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.