When I'm running my interface, I got this error message which specifies that the length of the column names is too long and yes most of my column names are too long and that is a requirement which I can not change. I've adjusted the max table and column length in topology to a huge number but this did not help. How can I solve this error?
Thank you for looking into this.
Oracle database doesn't accept names with more than 30 characters. So there is no way to use longer names if you use an Oracle DB.
So it's not a problem from ODI itself, it's a problem from your target DB ;).
Actually, the target tables and column names have been created by the DBA already. What do u think is the reason for him not facing that error?
and the error that I'm getting is during the creation of c$ table. My staging and target are on the same oracle DB.
Oh ok, so that's probably because the target table/column names are between 28 and 30 characters. So when ODI concatenates C$_ in front of that, you get a length of 31-33 chars.
You can change the prefix of these tables in the topology, but still, you need it to be at least 1 char, so if your target lengths are already 30 it won't work.
Maybe if you work with aliases for your column / datastores, the generated tables would use these aliases.
Could you try it ?
If you expand (with the +) your datastore in your model, you can see all the columns. Then if you double-click on a column, you can define a short_description.
I'm not sure it will be used for the temporary table, but you can try it :).
Yes, I did change the alias of the column name which is creating the problem and made it a short one but the temp tables are getting created not by the alias but by the actual column name. How can i use alias to create the temp tables. Where can I set this option?