ODI 12c IKM-LKM cut table names in target to a max of 30 characters
I'm mapping data from SQL Server to ADWCS. If I create manually a table in ADWCS I can overpass 30 characters limit.
If I run describe all_tab_columns;
I get:
Nombre | ¿Nulo? Tipo |
OWNER | NOT NULL VARCHAR2(128) |
TABLE_NAME | NOT NULL VARCHAR2(128) |
But when if a run the mapping from ODI with CREATE_TARGET_TABLE=true, in the target table names gets cut to a max of 30 characters.
I think this must be a IKM or LKM configuration, how can I set up to go over that limit and be able to create long names on target from ODI executions?