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?
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.
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?