How To Handle 30 Character Limit of Column Names in Oracle Database When Copying Models between Technologies in ODI 12c Studio
(Doc ID 2291171.1)
Last updated on OCTOBER 30, 2020
Applies to:Oracle Data Integrator - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Some Data Servers, such as Salesforce.com and SAP, allow column names (attributes) to have more than 30 characters maximum. Oracle database version 12c R1 and below only allows 30 characters.
When loading data from one technology to another, one of the features offered by Oracle Data Integrator (ODI) Studio is to copy the model from one technology to the other, and then have ODI create the tables. Ie, to load data from Salesforce.com to Oracle DB, the existing Salesforce.com models can be copied into an Oracle model using ODI Studio.
However, this causes issues as some of the "attributes" or column names can be larger than 30 characters in Salesforce.com, which is not allowed by Oracle.
How to truncate the attribute names intelligently and automatically so that the 30 character limit on Oracle database is respected? The column names must be unique.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document