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.