I am importing data from db2-dev server to stg table in SQL in 1st data flow task and bringing only few columns. -- This is done and works.
I need to bring remaining columns from deb-prod to this same stg table in SQL using another data flow task. Here I have db2 source and then lookup that compares db2 source with stg in SQL and then updates remaining columns.
But i only updates 1st column instead of all. Can u tell why? See below update statement.
The primary key in both DB2 dev and prod server table is same = ( Account _NO + Bill_Cycle_Date)
TOTAL_BILL_AMT_PROD = ?
,LPC_AMT_PROD = ?
WHERE ACCOUNT_NO = ?
AND BILL_CYCLE_DATE = ?