Need to update the existing records,The record which is coming for update should be inserted and also the previous record's one column must be modified. i have used look up to look up the data.used router to separate the data for insertion and update.Used expression to calculate something on those new records for update.service_code valid_startdate valid_enddate01 2003-03-03...

anu_v_iitd

 Profile Answers by anu_v_iitd Questions by anu_v_iitd

• Dec 13th, 2007

Actually what need to be done here is:You need to use two update strategy transformation just before inserting or updating the data into target table, Obviously there will be two instances of target t...

Answer Question  Select Best Answer