Issues with table/column name length
745723Mar 30 2010 — edited Mar 31 2010Hi,
I have to load data from xml source into oracle table. Some of the elements from the xml(that ODI reverses as datastores) are more than 30 characters long and the same goes for columns as well.
In topology manager, when I edit XML technology and go to "OTHERS" tab, both "Maximum Table Name Length" and "Maximum Column Name Length" are set to 30. According to the documentation, ODI should truncate the table name and the column name to the maximum length specified. But when I reverse the xml model, the datastores with more than 30 characters are created and this causes my interface to fail. Is there a solution for this problem?
Appreciate your response.
Thanks!