Four Stars

writing one row to multiple targets

how can I manage a case of writing one DB row to multiple targets using tmap ,and in case we have an exception in one of the targets, make a rollback to the others?

 

Thanks !

  • Data Integration
4 REPLIES
Nine Stars

Re: writing one row to multiple targets

You can use existing connection for all output components and onSubJobOk - tCommit, onSubJobError - tRollback

 

logic will be more complicated, but principles same

 

-----------
Four Stars

Re: writing one row to multiple targets

but this is for the whole input rows. what if I want to do this on only one row ?I don't want all rows to rollback , just the problematic one.
Nine Stars

Re: writing one row to multiple targets


chenkosto wrote:
but this is for the whole input rows. what if I want to do this on only one row ?I don't want all rows to rollback , just the problematic one.

:-) life is hard

 

seriously - check before insert for minimise exception, log errors, but never possible to do all what You want

of course You can process input row by row (iterate) ... but it take ages for finish ... or speed or ...

-----------
Four Stars

Re: writing one row to multiple targets

ok, how I do it with iterate?
can you send me a job description for example?