Loading single row from multible targets

[vasubaba]

Hi ,
I have a problem on mulitiple updates on single row.
like situation is like this:

from source 4 rows are comming and colouns are ID,In_ID
ID is a primary key in target,here in souce it is foreignkey.For in_id there re 4 corresponding
coloums re there in taget.Depending on the value of In_ID i need to check the values in target(if it is n, i need to set that as yes).
so what happened here is if i send all rows through this mapping its shows like only last row is updated,because it is overwriting the the first 3 rows values, any time only one row is updated.
but i want all 4 fields need to updated

 

[blom0344]

You are trying to update multiple fields the wrong way.
(1)
Either use a one-pass update containing the updates you want to make using a single record for each update or:

(2)

Create a multi-pass update where each session updates a certain field in the target.

I think in your case you should attempt to aply strategy (2) to split the 4 records coming from the source into 4 different mappings and the creating 4 sessions that run sequentially to do the updates you need.......... T. Blom
Information analyst
tbl@shimano-eu.com