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.