Been a long time since I'd posted last in this forum. Hope you all are doing well .
I came with a pretty odd hitch that we faced in one of our parallel jobs.
But the real trouble is, the same design is used in multiple other jobs as well, hence an error here would mean that changes are required in all the other jobs also.
The job consists of three parallel data load flows, and the generic structure for all these loads are as follows:
Code: Select all
SEQUENTIAL FILE --> TRANSFORMER -- > ORACLE CONNECTOR
I ran the After SQL statement independently and it ran fine, but somehow when fired as a post sql from the OCI stage it is getting skipped.
Any idea as to how to go forth in finding the root cause of this problem?
Regards
Kumarjit.