Amazon Redshift Connectors

Back Next

Rules and guidelines for creating a target

The Secure Agent converts the target table names that you specify in the

Create Target

field into lower case.

When you create a target, you can view and edit the metadata of the target object in the

Target Fields

tab. You can edit the data type, precision and define primary key of the columns in the target objects. To edit the metadata, click

Options

Edit Metadata

in the

Target Fields

tab.

Consider the following rules and guidelines when you create a target:

When you create a target if the source table contains column of Text data type, the Secure Agent displays the following error message:

Unsupported datatype - 'text' for column
'LONGTXTAREA__C'

You must edit the data type of the source column in the Source transformation.

You cannot parameterize the target at runtime.

When you create a target and specify a table name or column name in uppercase or mixed case alphabets, the Secure Agent converts the target table name or column name into lowercase alphabets and the mapping task runs successfully. However, the tomcat log shows the following error message:

An unexpected exception occured while fetching metadata:[The following object is not found].

When you create a target with Time data type, the new target will have the data type as Timestamp.

When you run a mapping task with a vaccuum command using the pre-SQL or post-SQL queries, the mapping fails.

When you write to a target and the target connection has Auto Create DBuser
enabled, the new user cannot truncate a table created by an existing user.

Rename Saved Search

Table of Contents

Amazon Redshift Connectors

Amazon Redshift Connectors

Rules and guidelines for creating a target

Rules and guidelines for creating a target