Database stage types
The Balanced Optimization tool can only optimize jobs that contain certain types of database connector stages or Big Data File stages.
Teradata connector
Only the Teradata connector is supported for optimization. Other Teradata access stages are not supported for optimization.The Teradata connector requires the Teradata Parallel Transporter interface to be installed on each InfoSphere® DataStage® node that will run jobs containing the Teradata connector.
Join,
lookup, and funnel stage processing in a job can be pushed into a
Teradata connector source or target only if all the Connection property
values of the involved connector stages are compatible. All such
stages must have the same values for Server, Username,
and Password properties. These values can
be literal values or job parameters. The database properties of all
such stages must be compatible, and conform to one of the following
schemes:
- Database properties of all involved connectors are set to blank (the empty string). Because Server and Username properties are the same, all these connectors refer to the same default Teradata database for the specific Teradata server and user name.
- Database properties of all involved stages are set to explicit non-blank values, including literal values or job parameters.
DB2 connector
Only the DB2® connector is supported for optimization. Other DB2 access stages are not supported for optimization.InfoSphere Balanced Optimization does not support quoted identifiers in the DB2 connector.
Netezza connector
Only the Netezza connector is supported for optimization. Other Netezza access stages are not supported for optimization.InfoSphere Balanced Optimization does not support quoted identifiers in the Netezza connector.
Oracle connector
Only the Oracle connector is supported for optimization. Other Oracle access stages are not supported for optimization.InfoSphere Balanced Optimization does not support quoted identifiers in the Oracle connector.
Big Data File stage
InfoSphere Balanced Optimization supports optimization for Big Data File stages.