topic Re: writing one row to multiple targets in Talend Studio

writing one row to multiple targets

Anonymous — Mon, 29 May 2017 13:41:10 GMT

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 !

Re: writing one row to multiple targets

vapukov — Mon, 29 May 2017 14:44:35 GMT

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

logic will be more complicated, but principles same

Re: writing one row to multiple targets

Anonymous — Mon, 29 May 2017 14:48:53 GMT

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.

Re: writing one row to multiple targets

vapukov — Mon, 29 May 2017 14:52:42 GMT

@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 ...

Re: writing one row to multiple targets

Anonymous — Mon, 29 May 2017 14:59:11 GMT

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