Pivot stage poor performance

seanc217 · Post by **seanc217** » Tue Oct 24, 2006 4:04 pm

I have a sequential file stage which goes to a transformer. One link out of the transformer goes to an Oracle stage and another goes to a pivot stage where I pivot 60 columns 9 times. I am getting very poor performance on this. If I remove the pivot stage and run the job it runs much faster. Anyway if anyone has suggestions let me know. If you need more info, I will get it.

Thanks for any ideas.

Sean

Ultramundane · Post by **Ultramundane** » Tue Oct 24, 2006 8:36 pm

I have never been able to get good performance from the pivot stage. I use awk. I was told by IBM that the pivot stage would be faster in V8.0.

seanc217 · Post by **seanc217** » Wed Oct 25, 2006 7:32 am

Well...
I am running Hawk Beta 2A and this is not the case. Hopefully they fix this by GA?

I guess I will land each occurence to a dataset and load them that way.

Thanks,

Sean

DSXchange

Pivot stage poor performance

Pivot stage poor performance

Re: Pivot stage poor performance