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
Pivot stage poor performance
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 407
- Joined: Mon Jun 27, 2005 8:54 am
- Location: Walker, Michigan
- Contact:
Re: Pivot stage poor performance
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.