Hi,
I want to know why the grouping functionality is available in the PIVOT stage
As we cannot do any aggregate function in this stage
I tried grouping and it gave me the same answer as it would give without grouping. I am failing to understand the importance
Can any one explain?
Thanks
Group feild in PIVOT stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Do you use a hammer to fasten wood screws? Or a sieve to cart water?
Use the right tool!
The Pivot stage does horizontal pivots.
The Aggregator stage does aggregation.
The FTP stage does FTP.
And so on.
That's the main principle underlying the graphical paradigm that DataStage uses.
Use the right tool!
The Pivot stage does horizontal pivots.
The Aggregator stage does aggregation.
The FTP stage does FTP.
And so on.
That's the main principle underlying the graphical paradigm that DataStage uses.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
So the grouping functionality is not useful.....ray.wurlod wrote:Do you use a hammer to fasten wood screws? Or a sieve to cart water?
Use the right tool!
The Pivot stage does horizontal pivots.
The Aggregator stage does aggregation.
The FTP stage does FTP.
And so on.
That's the main principle underlying the graphical paradigm that DataStage uses.
then why is it there