Aggregator stage derivation definition
Posted: Tue Mar 30, 2010 2:17 am
Is there an easy way to define the derivations for an aggregator stage.
A lot of times we have jobs where the input of the aggregator stage is a collection of a lot of columns, and the output is the same set of columns where a few columns are grouped on, and the rest are summarized.
This requires a lot of mouse-clicks and for each field browsing through the list of columns to pick the correct corresponding input-field with the same name.
Is there an easier way to do this?
A lot of times we have jobs where the input of the aggregator stage is a collection of a lot of columns, and the output is the same set of columns where a few columns are grouped on, and the rest are summarized.
This requires a lot of mouse-clicks and for each field browsing through the list of columns to pick the correct corresponding input-field with the same name.
Is there an easier way to do this?