DataStage Migration 6 to 7.5
Posted: Wed Feb 22, 2006 2:17 am
Hi All,
While migrating the job from 6 to 7.5 ,One job js running for quite long time which is extracting the data from the oracle table .Infact its running big extration querry in ORAOCI8.
I ran same querry on sql pls .there also it ran for long.
However the same job took very less time whilce running on DS-6 on the same table and same database.
All ready searched the forum.
Can any body suggest?
Thanks
Prashant
While migrating the job from 6 to 7.5 ,One job js running for quite long time which is extracting the data from the oracle table .Infact its running big extration querry in ORAOCI8.
I ran same querry on sql pls .there also it ran for long.
However the same job took very less time whilce running on DS-6 on the same table and same database.
All ready searched the forum.
Can any body suggest?
Thanks
Prashant