Merge a server Pivot and Hashed stages...
Posted: Wed Feb 27, 2008 2:17 pm
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.
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.