Tasks

Back Next

Table and column names in a database target

The

replication

task replicates source objects and fields to target database tables and columns, respectively. In certain cases, the

replication

task does not give the target table and column names the same names as the source objects and fields.

The

replication

task might not give the same names in the following circumstances:

You write replicated data to a database target and use a table name prefix.

A table name prefix prevents you from overwriting database tables when you share a database account.

You replicate case-sensitive data.

When the

replication

task replicates data to a target database, it creates all table and column names in uppercase. If the target database is case sensitive, use uppercase table and column names when you query the database.

You replicate objects with long object and field names.

When a source object or field name contains more characters than the maximum allowed for the name in the target, the

replication

task truncates the table or column name in the target database.

Replication tasks

Table name truncation

Duplicate tables names from same replication task

Duplicate table names from different replication tasks

Column name truncation

Download Guide

Watch

Comments

Cloud Data Integration Homepage

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Tasks

Tasks

Table and column names in a database target

Table and column names in a database target