Tuning a Ds job involving Oracle stages
Posted: Tue Nov 04, 2008 11:37 pm
Hi,
I am dealing with tuning a DS job which mainly involves oracle stages.
job contains two oracle stages whose output is clubbed using a funnel stage,written into a sequential file.
the query in oracle stage-1 will resemble
select c1,c2,c3 from t1,t2,t3
the query in oracle stag-2 will resemble
select count(t4.c1),sum(t4.c2) from
(select c1,c2,c3 from t1,t2,t3
)t4
from the datastage logs each of these satges are taking around 1.2hrs.because of parallel execution the job is getting completed in 1.2hrs.
what I am thinking of is as the part of logic (select c1,c2,c3 from t1,t2,t3) is same in both the satges,I am planning of doing both these stages in a single stage by creating a temp table.
what I want to know is.
1)Is my aproach correct
2)can I create a temp table in datastage(if yes,please tell me,how?).
please help me find a solution.
I am dealing with tuning a DS job which mainly involves oracle stages.
job contains two oracle stages whose output is clubbed using a funnel stage,written into a sequential file.
the query in oracle stage-1 will resemble
select c1,c2,c3 from t1,t2,t3
the query in oracle stag-2 will resemble
select count(t4.c1),sum(t4.c2) from
(select c1,c2,c3 from t1,t2,t3
)t4
from the datastage logs each of these satges are taking around 1.2hrs.because of parallel execution the job is getting completed in 1.2hrs.
what I am thinking of is as the part of logic (select c1,c2,c3 from t1,t2,t3) is same in both the satges,I am planning of doing both these stages in a single stage by creating a temp table.
what I want to know is.
1)Is my aproach correct
2)can I create a temp table in datastage(if yes,please tell me,how?).
please help me find a solution.