Preface
Data integration tasks
Mapping tasks
Dynamic mapping tasks
Synchronization tasks
Data transfer tasks
Replication tasks
Masking tasks
Masking rules
PowerCenter tasks

Tasks

Back Next

Table name truncation

When you replicate a source object to a database, the

replication

task replicates the data to a database table with the same name as the source object.

If you replicate data to a database target and the length of the source object name exceeds the maximum number of characters allowed for the target table name, the

replication

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

Table and column names in a database target

Download Guide

Watch

Comments

Cloud Data Integration Homepage