Hi please help me onthis...
Posted: Wed Feb 20, 2008 1:46 am
Hi.. i have job design in server jobs......where i have to convert number of rows to no of columns.....
i have designed a job by using pivot stage, where i will get 30,00,000 Records from source.
Now this job is running for 30mins..Please help me to increase the performance.
Please see the sample recodrs below..
Source:
Sysdate,HK,ODS,100,200,300,400,500,a,b,c,d,e,1,2,3,4,5,XXX
Target:
Sysdate HK ODS 100 a 1 XXX
Sysdate HK ODS 200 b 2 XXX
Sysdate HK ODS 300 c 3 XXX
Sysdate HK ODS 400 d 4 XXX
Sysdate HK ODS 500 e 5 XXX
i have designed a job by using pivot stage, where i will get 30,00,000 Records from source.
Now this job is running for 30mins..Please help me to increase the performance.
Please see the sample recodrs below..
Source:
Sysdate,HK,ODS,100,200,300,400,500,a,b,c,d,e,1,2,3,4,5,XXX
Target:
Sysdate HK ODS 100 a 1 XXX
Sysdate HK ODS 200 b 2 XXX
Sysdate HK ODS 300 c 3 XXX
Sysdate HK ODS 400 d 4 XXX
Sysdate HK ODS 500 e 5 XXX