Hello Sandhu,
If you want the rows from the source table to update the target's existing rows AND insert if it doesn't find a match, you should create a lookup to the target to find out which s_account_id's do match the target's account_ids.
Create a lookup to the target, in the condition of the lookup you should have s_account_id = account_id.
The output of the lookup (perhaps you would name it out_account_id) is then passed to the update strategy along with s_balance from the source.
In the condition of the update strategy, you should have IF (out_account_id is null, DD_INSERT, DD_UPDATE).
What this is saying is:
"If the result of the lookup to the target is null (no matches), then insert the row, else, update the row."
does this help?
I have additional Questions for you:
Did you want to keep a history in your target table?
Target table data with history
===========
Account_ID (pk) Balance Date
111 200.00 08/07/03
222 200.00 08/07/03
333 500.00 08/07/03
111 100.00 08/08/03
222 100.00 08/08/03
333 500.00 08/08/03
or did you just want to have current data?
-dinzana