PowerExchange for Amazon Redshift User Guide

Back Next

Target Schema Strategy

You can choose to retain an existing target table or create a new target table in the target when you run a dynamic mapping.

You can select one of the following options in the

Target Schema Strategy

advanced properties for the data object write operation:

RETAIN - Retain existing target schema: The Data Integration Service retains the existing target schema.; When you select
RETAIN
option and if the target table does not exist or the metadata of the source and target tables do not match, the mapping fails.

CREATE - Create or replace table at run time: The Data Integration Service creates a new table based on the data object or the mapping flow if the table does not exist in the target.; When the Data Integration Service creates a table based on the data object, the table contains columns that match the ports in the data object. When the Data Integration Service creates a table based on the mapping flow, the table contains columns that match generated ports in the Write transformation.; When you select
CREATE
option and if the table already exists in the target, the mapping fails with an error message stating that the target table already exists.

Assign Parameter: You can assign a parameter to represent the value for the target schema strategy and then change the parameter at run time.