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.
InfoSphere DataStage Balanced Optimization does not support quoted identifiers in the Teradata connector.

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.