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

Dynamic Targets

A dynamic target is a target that can change at run time. You can configure flat files and relational targets to be dynamic.

When you run a mapping, a dynamic target can get metadata changes from physical data targets, including relational tables, flat files, and customized data objects. It can also generate columns based on the upstream column definitions.

You can configure dynamic run-time functionality for a target in the following ways:

Get columns from the data source.: When you expect small changes to the target, you can configure the Write transformation to get relational object columns at run time. When you configure the Write transformation to get metadata from targets, you can configure the Write transformation to update dynamically and remain synchronized with target objects.
Define target columns based on the mapping flow.: When you define columns based on the mapping flow, target columns are determined by upstream transformations.
Define target columns based on the data object.: When you define columns based on the data object, target columns are determined by the associated data object.
Create or replace relational target tables at run time.: By default, when you configure the Write transformation to create or replace the target at run time, the Data Integration Service creates the target based on the data object. You can also choose to create the target based on the mapping flow, or you can define a DDL query to create the target based on the query.
Assign a parameter to determine the resource, table owner, or directory of a relational data object.: When the relational targets are similar, you can assign a parameter to get the resource, connection, and table owner properties.
Assign a parameter to determine the data object to use for a file or relational target.: You can create a customized data object as a Write transformation, and specify a parameter value as the target for the transformation. When you change the value of the parameter, the target changes for all objects that use the parameter.

The following table shows where you can configure the dynamic run-time functionality of a target:

Dynamic Run-time Target Functionality	Configuration
Get columns from the data source.	Configure the Data Object tab on the Write transformation for the following target type: Relational
Define target columns based on the data object or the mapping flow.	Configure the Ports tab on the Write transformation for the following target types: Flat file Relational
Create or replace the table at run time.	Configure the Advanced tab on the physical data object for the following target type: Relational
Define a DDL query to create the target table at run time.	Configure the Advanced tab on the physical data object for the following target types: Relational Hive
Assign a parameter to determine the connection, owner, or resource.	Configure the Run-Time tab on the Write transformation for the following target type: Relational
Assign a parameter to determine the data object.	Configure the Data Object tab on the Write transformation for the following target types: Flat file Relational