Job design considerations

There are some limitations to the optimizations that can be performed on InfoSphere® DataStage® jobs.

The SQL that is native to the source or target databases does not support some of the capabilities of InfoSphere DataStage and so that functionality cannot be pushed to a source or target database.