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
getting warnings when i am inserting records.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom