How To Handle 30 Character Limit of Column Names in Oracle Database When Copying Models between Technologies in ODI 12c Studio
Last updated on OCTOBER 27, 2017
Applies to:Oracle Data Integrator - Version 22.214.171.124.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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms