HI, I need inputs please.. I

[INFEXP]

HI,

I need inputs please..

I have a mapping with a single stream and 3 oracle Target instances of the same table..

For the 1st and 2nd target instance i need to insert data and for the 3rd instance do a lookup on the target table, but the problem being the data has not been commited to the table by 1st or 2nd instance and hence the lookup fails..i can get around with this problem by putting a Transaction Control before the target, but that will slow the process..is there a better way avoiding Stored procedure or TC.

 

[cprashanth]

Hi ,

why don't break up the mapping in two mappings which will be simpler i guess.

The first mapping will do the insertion in two tables, and the second mapping will do an update depending up the target table.

Pls give a try and see.

-Prashanth

 

[tkrish]

Hi INFEXP,

You can split your mapping into two different flows.

Do the insert in one flow and in the other flow do the update.

It should be a very simple change.

tkrish