Hello,

Many thanks in advance for your support.

I have a transformation where 4 sql loader instances get started for loading the data into oracle tables. Please find the attachment (It is just a trial ktr).

The requirement is, if any one of the sql loader instance returns non-zero value, I have to rollback.

May be, I can say, if all the sql loader instances return zero, then it should commit else rollback.

I need to load millions of transformed data and I have more than 300+ tables to be loaded having different foreign keys references with different columns like a chain among them.

I doubt table outstep can be used but I doubt performance constraints.

Is there any turn around solution ? or any idea, please let me know.

test.ktr