You cannot define a primary key on the target table.

You must select the connection for the new target data object in the

Connection

property after you create a new target.

You must import an Amazon Redshift data object in the Developer tool to read the tables from the newly created target.

The Data Integration Service creates the new target table with the name specified in the

Native Name

property in the

Data Object Details

tab or the

Table Name

advanced properties of the data object write operation.

When you create a new target, the Data Integration Service maps all the binary port from the source to the string port in the target.

When you create a new target, the Data Integration Service creates all the columns of the target table in the following manner:

Creates all the columns of the target table as nullable.
Creates all the columns of the SmallInt, Int, and Boolean data types as Bigint data type.
Creates all the columns of the Date data type as Timestamp data type.
Creates all the columns of the String data type as Varchar data type.

When you create a new target, you must select the value of the

Target Schema Strategy

property as

CREATE

and provide the value of the

Schema Name

property.