The problem I'm facing is: I am using LOAD in Oracle Enterprise stage and the job is failing because the control file is being truncated. The same job runs fine with another schema which has relatively less columns compared to the one failing. The DBA says its something Datastage may be doing. If that is true, is there a way to over-ride it?
The text control file was truncated exactly at 10KB and the director log shows the last characters of the file which does confirm truncation.
The Datastage error screenshot and the incomplete Control file are attached.