I would love to have an active stage that is similar to a hashed file stage with one input and one output link. This stage would not land data on disk, but would allow the incoming row to be normalized on the fly.
This would be more flexible than a pivot stage, because one incoming row could generate a variable number of outgoing rows. Additionally, it would preserve the order of data, something that is lost when writing then reading from a normalized hashed file.
Merge a server Pivot and Hashed stages...
-
- Premium Member
- Posts: 385
- Joined: Wed Jun 16, 2004 12:43 pm
- Location: Virginia, USA
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can always include a sorting clause on the Selection tab when reading from a Hashed File stage.
Syntax is that of the RetrieVe query language.
BY field (for ascending order)
BY.DSND field (for descending order)
You need one clause for each sorted field.
For example: BY REGION BY COUNTY BY.DSND SALES
Syntax is that of the RetrieVe query language.
BY field (for ascending order)
BY.DSND field (for descending order)
You need one clause for each sorted field.
For example: BY REGION BY COUNTY BY.DSND SALES
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.