Wizard Limitations
The Wizard has the following limitations:
Jobs created on the Wizard can contain only a single job step.
The job can only perform SELECTs, INSERTs, and UPSERTs. Wizard scripts must be manually
altered to perform other functions.
The Update and Stream operators can operate only against a single table. They only
perform INSERTs, and UPSERTs.
A maximum of 450 columns can be defined in the source table or source record.
The Wizard only supports the OCI driver type 2 of the Oracle JDBC driver.