4 Replies Latest reply: Feb 12, 2013 3:49 AM by 982678 RSS

    ODI KMs column names enclosed in quotes

    982678
      Hello there,

      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.

      Thanks & Regards,

      Matthew
        • 1. Re: ODI KMs column names enclosed in quotes
          Sutirtha Roy
          979675 wrote:
          Hello there,

          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.
          Check the column name in database
          Are they in small case in one env ?
          ODI use quote in case of smaller case column name
          Thanks & Regards,

          Matthew
          • 2. Re: ODI KMs column names enclosed in quotes
            982678
            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?

            Thanks,

            Matt
            • 3. Re: ODI KMs column names enclosed in quotes
              actdi
              Matthew,

              A fundamental piece of information is missing from the equation : The version of ODi that you are using ?
              • 4. Re: ODI KMs column names enclosed in quotes
                982678
                Hi actdi

                On Dev we're running 11.1.1.60. On Deployment server we're running ODI 11.1.1.63