2 Replies Latest reply: Jul 23, 2014 8:54 AM by 2714695 RSS

    ODI 11g - IKM Skips/eliminates some fields

    2714695

      Hi gurus

       

      I have a problem with ODI 11g skipping some fields in Integration part.

      It loads the data from source to staging with no problem (it has all the fields), but when it tries to load from staging to actual target (Integration) it eliminates some field names and because one of those is actually my PK so it fails and says

      ORA-01400: cannot insert NULL into AddressID (the PK)

      I can see in session log step (Integration) that the query it tries to run to SELECT from Staging and INSERT to Target doesnt even have those fields

       

      Source : MS SQL Server 2005

      Target: Oracle 11g

       

      This is the KM Im using :

      LKM SQL to Oracle

      IKM SQL Control Append

       

      Any help would be appreciated

       

      Thanks,

        • 1. Re: ODI 11g - IKM Skips/eliminates some fields
          Bhabani Ranjan

          Normally ODI skips the unmapped columns. Can you copy pest the generated codes?

          Also what about your staging? Is it on target server?

           

          Thanks

          Bhabani

          • 2. Re: ODI 11g - IKM Skips/eliminates some fields
            2714695

            Bhabani

             

            The skipped columns are mapped in my interface

            Yes the staging is on target server

             

            Here is the code(as you can see those fields I mentioned in picture, is missing in the query):

             

             

            insert into GDW_DA_006."Address"

            (

              "AddressTypeID",

              "Line1",

              "Line2",

              "City",

              "State",

              "ZipCode",

              "CountryID",

              "CreateDate",

              "ActiveInd",

              "SavedDate",

              "SavedBySecurityUserID"

              ,CRE_DATE

            )

             

             

            select

                "AddressTypeID",

              "Line1",

              "Line2",

              "City",

              "State",

              "ZipCode",

              "CountryID",

              "CreateDate",

              "ActiveInd",

              "SavedDate",

              "SavedBySecurityUserID"  

              ,SYSDATE

            FROM (

             

             

            select

              C2_ADDRESSTYPEID "AddressTypeID",

              C3_LINE1 "Line1",

              C4_LINE2 "Line2",

              C5_CITY "City",

              C6_STATE "State",

              C7_ZIPCODE "ZipCode",

              C8_COUNTRYID "CountryID",

              C9_CREATEDATE "CreateDate",

              C10_ACTIVEIND "ActiveInd",

              C12_SAVEDDATE "SavedDate",

              C13_SAVEDBYSECURITYUSERID "SavedBySecurityUserID"

            from GDW_DA_006."C$_0Address"

            where (1=1)

             

            )    ODI_GET_FROM

             

             

            mapping.jpg