1 Reply Latest reply on Nov 12, 2019 7:32 PM by Adrian_Popescu-Oracle

    ODI 12c CKM TERADATA - FLOW CONTROL REPEATS THE SAME COLUMN FOR CHECK NULL

    4020052

      Hi,

       

      I have the following situation:

       

      I created a simple mapping in ODI 12c (version ODI_12.2.1.2.6_GENERIC), In my mapping the source table is a flat file (.csv) and my target table is a table in teradata.

       

       

      This mapping is using Control Append with a primary key defined in the target table SMAGENT_SALE_NT

       

      The PK_COMPUESTA2 is defined below:

       

       

       

      And the columns are checked to "check not null"

       

       

      In Physical tab "INTEGRATION KNOWLEDGE MODULE" is 'IKM TERADATA CONTROL APPEND', and flow control is set to true

       

       

      In "CHECK KNOWLEDGE MODULE" is "CKM TERADATA"

       

       

      The problem:

       

      When the process start the step of "Check for Null" REPEATS THE SAME COLUMN EVERY TIME, I notice that is the first column "StoreInitial" of PRIMARY KEY.

       

      where clausule:

       

      If I remove the PRIMARY KEY "PK_COMPUESTA2" the process not "recognize" the columns anymore. It cause a "blank" column in where clausule and raise a error.

       

       

       

      Somebody can help me?

       

       

      This problem is drive me crazy....

       

       

      Thanks in advance.