Skip to Content
0
Former Member
Jun 11, 2009 at 01:33 PM

DB-DB (Transaction at Sender - Record by Record Processing at Receiver)

30 Views

Dear All,

We have a scenario wherein we should read 4000 records from sender DB system and insert them in target DB. If there is any failed record, the whole transaction should not be failed even if there is an error with one record instead we should know the failed record details so that we can ask the sender to resend the data after correcting the data in that record.

In short, all the succesfull records of 4000 should be inserted/updated and the failed records shuold be separated so that PI support person can intimate sender to resend the data after fixing the issue.

Any Clues on this.

Regards,

Srini

Edited by: Srinivasa Babu Mutyala on Jun 11, 2009 3:36 PM