Oracle native stage is taking more time to retrieve Data
Posted: Fri Jul 04, 2008 3:11 am
Hi
One of my job source is data is fetching from oracle database through oracle native stage, Data is retrieving through user defined SQL it contains Co-related sub query and right outer join.
If retrieve same query by using SQL Plus or TOAD it is taking just 30sec but job is having only 3stages first id oracle,Transformer and target is flat file this job is taking more than 25min to finish
Can any body please suggest me how I can improve the performance of this job
and job is running in parallel mode with 2node
Thanks
One of my job source is data is fetching from oracle database through oracle native stage, Data is retrieving through user defined SQL it contains Co-related sub query and right outer join.
If retrieve same query by using SQL Plus or TOAD it is taking just 30sec but job is having only 3stages first id oracle,Transformer and target is flat file this job is taking more than 25min to finish
Can any body please suggest me how I can improve the performance of this job
and job is running in parallel mode with 2node
Thanks