Unit of Work in DS

roy · Post by **roy** » Mon Aug 04, 2003 7:25 am

well this is time consuming but rather simple.
load all 5 to a table then use 1 load from that 1 to your real production in 1 transaction.

Hope this helps,

Roy R.

chulett · Post by **chulett** » Mon Aug 04, 2003 7:31 am

If Oracle, you can use a single OCI stage as the target. This will give you access to 'Transaction Grouping', which will allow you to do what you want.

-craig

ariear · Post by **ariear** » Mon Aug 04, 2003 7:35 am

I believe that transaction grouping is available only if all the links are coming out from the same transformer

chulett · Post by **chulett** » Mon Aug 04, 2003 10:50 am

True, forgot to mention that little caveat. [:I] Unfortunately, it's the only way to enable the 'all or nothing' automatic rollback capability that the OP mentioned, AFAIK. Otherwise, you'd have to design more of a 'remove' functionality into the job in case of failure, I would guess...

-craig