This content has been marked as final. Show 4 replies
979675 wrote:Check the column name in database
One of the issues we're having to deal with on ODI is that on our development environment the KMs are generating the column names with quotes wheras on another environment the exact same KMs are generating the column names without quotes.
What gives? How come the exact same KMs produce such a fundamental difference in the result? I havent been able to figure out what's causing this change either, so any pointers in that direction would be greatly appreciated.
Are they in small case in one env ?
ODI use quote in case of smaller case column name
Thanks & Regards,
Definitely not the case since we have exact copies of the live MSSQL "source" database which we took from live and our Oracle database is initially empty.
I suspect there is some sort of setting or parameter that is set up differently between the dev and live environments? What causes the ODI to generate column names in this way? Is it maybe that column names are automatically converted when we put everything in a solution and do the export?
A fundamental piece of information is missing from the equation : The version of ODi that you are using ?
On Dev we're running 220.127.116.11. On Deployment server we're running ODI 18.104.22.168