Page 1 of 1
Posted: Mon Aug 04, 2003 7:25 am
by roy
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.
Posted: Mon Aug 04, 2003 7:31 am
by chulett
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
Posted: Mon Aug 04, 2003 7:35 am
by ariear
I believe that transaction grouping is available only if all the links are coming out from the same transformer
Posted: Mon Aug 04, 2003 10:50 am
by chulett
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