If you have source tables with long column names, alternative strategies are available for handling the long column names so that the corresponding column names on the target do not exceed the maximum length that the target database allows.
Use one of the following strategies to shorten column names in generated audit log tables or target tables on the target:
For audit log table columns that contain before- and after-images, use suffixes that are shorter than the default suffixes of _OLD and _NEW. For example, you can use _O and _N as the suffixes.
For Merge Apply or SQL Apply mode, create a script that generates regular target tables or audit log tables with shorter column names. In this case, the Data Replication Console cannot map columns based on column names. You must map these columns manually.
For replications that use Merge Apply mode with Teradata targets, create views that have shorter column names for the target tables and generate audit log tables based on these views. The column names in the views are truncated, but the Data Replication Console ensures that the names are unique. When defining mappings, map the views to the source tables.