Pivoting in DS

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Theoretically no, unless you run out of memory (you didn't specify whether you're running this on a PalmPilot [:D] and you didn't specify how large those columns were).
As with the Aggregator stage, it can help if the incoming data are sorted on the key (pivoting) fields.


Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

No, you can't run DataStage on a Palm Pilot! [:D]
Post Reply