DSXchange

Hi

The existing job is designed like this. Force source sequential files are club using Funel stage and insert in to target table.

it is through warnings. That is why i was modifed the jobs after Funel stage
i used change capture and insert the records to the target table.

Sequential files -- Funel stage -- change capture -- Transformer -- DB2 target table.

Now i am getting the warning like this.

Copy_of_DB2_LOAD_SRK,0: Warning: CopyOfRNESD18L.DB2_LOAD_SRK: UNIQUE_ID_VAL = 207341_6_10_2008-07-31_1_1_NS_NULL_NULL_NULL_NULL_NULL_NULL TBL_SRKEY = 1430854 TBL_NM = TN1ODAPD SRC_SYS = EFF_DTE = 8-09-18 END_DTE = NULL

That definitely cannot be the complete unedited message.

Post in full.

Right, that's your problem row not your actual problem which will be logged separately. Post your problem.