I have the following situation:
I created a simple mapping in ODI 12c (version ODI_18.104.22.168.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"
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.
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.
Try using a generic IKM, like "IKM SQL Control Append" and "CKM SQL".