Handling Nulls in Aggregator
Posted: Wed Jun 06, 2007 8:20 am
Hello All:
I have a quick question on using the Aggregator stage (Enterprise Edition).
I have an AMT column which is a nullable column and it passes through the Aggregator to determine the sum, based on a set of grouped key columns. When the AMT column is null at the source the data after aggregation shows 0.
Since 0 and Null's are different, i was wondering how to get NULL's at the Output.
Any Suggestions are welcome !!
Thanks All !!
I have a quick question on using the Aggregator stage (Enterprise Edition).
I have an AMT column which is a nullable column and it passes through the Aggregator to determine the sum, based on a set of grouped key columns. When the AMT column is null at the source the data after aggregation shows 0.
Since 0 and Null's are different, i was wondering how to get NULL's at the Output.
Any Suggestions are welcome !!
Thanks All !!