DSXchange

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

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.

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