We are trying to load some large tables for Sybase IQ to Oracle via Oracle OCI Bulk stage. Some of the columns contain the characters | & " and that is causing the bulk loader to return errors given below.
1. Record 14294: Rejected - Error on table DW.D_VENDOR, column ENABLED_FLAG.
ORA-01722: invalid number
2. Record 11048: Rejected - Error on table DW.D_VENDOR, column VENDOR_NAME.
no terminator found after TERMINATED and ENCLOSED field
Since numeric columns cannot contain those special characters, ensure that they aren't put in there - several DataStage methods exist including string replacement and numeric conversion functions. For error number (2) please post line 11048 to see exactly what error is in the data.