Oracle native stage is taking more time to retrieve Data

[sgpatil]

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

[ArndW]

TOAD and SQLPLUS do not return all the data immediately, so this time comparison is probably not valid.