Tasks

Back Next

Column name truncation

If the length of the source field name exceeds the maximum number of characters allowed for a column name in a relational target, the

replication

task truncates the column name in the target database. It truncates the column name to the first X characters, where X is the maximum number of characters allowed for a column name in the target database.

For example, the

replication

task creates a column name in an Oracle database based on the following 40-character field name of a Salesforce object:

TenLetters1234567890TenLettersXXXXXXXXXX

The

replication

task truncates the column name to the first 30 characters:

TenLetters1234567890TenLetters

If the truncation causes duplicate column names for the target table, the

replication

task replaces the last character of the duplicate column names with sequential numbers. The

replication

task also replaces the last character of duplicate table names from the same task.

Table and column names in a database target

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

Column name truncation

Column name truncation