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

Defining Write Transformation Ports

Define target object columns by mapping flow to enable upstream mapping objects to update the incoming ports for the Write transformation.

In the

Properties

view, click the

Ports

tab.

Select

Columns defined by: Mapping flow

The following image shows the

Ports

tab populated with ports defined by the associated data object:

Enable dynamic ports and targets:

Drag upstream ports to the

input

pane of the Write transformation.

The target gets column definitions from upstream mapping objects.

In the

Properties

view, click the

Advanced

tab.

Select

Create or replace table at run-time

The following image shows the

Create or replace table at run-time

option in the Advanced tab of the target object: To configure a Write transformation to create or replace the target table at run time, select the option in the Advanced tab.

To configure a Write transformation to create or replace the target table at run time, select the option in the Advanced tab.

At run-time, the Data Integration Service creates, or drops and replaces, the target table.

When a mapping contains multiple targets whose columns are defined by the same physical data object, enable the

Create and replace table at run-time

option for only one of the targets. If you enable this option for more than one target, the metadata of the table that the mapping creates would match only one of the targets, and the mapping fails.

Rename Saved Search

Table of Contents

Developer Mapping Guide

Developer Mapping Guide

Defining Write Transformation Ports

Defining Write Transformation Ports