NULL Handling in Aggregator
Posted: Mon Sep 08, 2008 6:00 pm
Hello,
This is my job design:
"DB2--TRANSFORMER--FUNNEL---AGGREGATOR--FUNNEL---DATASET"
I have a field "amt1" coming from the DB2 which is nullable. I'm handling this nullability in the transformer by specifying it should take a value of 0 if it is null. The output of this goes to a funnel and then to an aggregator where I'm aggregating this "amt1" and outputting it to the rest of my job. This output(aggregate of 'amt1') is non-nullabe.
When I run my job it runs fine,but gives me warnings saying:
"Aggregator: When checking operator: When binding output interface field "amt1" to field "amt1": Converting a nullable source to a non-nullable result;
a fatal runtime error could occur; use the modify operator to
specify a value to which the null should be converted."
This warning is in the aggregator stage and I'm stuck here and do not know how to proceed further by removing this warning. I tried changing the nullability option in the column definitions of the aggregator stage and yet it still shows this warning.
Is there anyway I can handle this warning. Any help would be really appreciated.
Thanks,
dscon9128
This is my job design:
"DB2--TRANSFORMER--FUNNEL---AGGREGATOR--FUNNEL---DATASET"
I have a field "amt1" coming from the DB2 which is nullable. I'm handling this nullability in the transformer by specifying it should take a value of 0 if it is null. The output of this goes to a funnel and then to an aggregator where I'm aggregating this "amt1" and outputting it to the rest of my job. This output(aggregate of 'amt1') is non-nullabe.
When I run my job it runs fine,but gives me warnings saying:
"Aggregator: When checking operator: When binding output interface field "amt1" to field "amt1": Converting a nullable source to a non-nullable result;
a fatal runtime error could occur; use the modify operator to
specify a value to which the null should be converted."
This warning is in the aggregator stage and I'm stuck here and do not know how to proceed further by removing this warning. I tried changing the nullability option in the column definitions of the aggregator stage and yet it still shows this warning.
Is there anyway I can handle this warning. Any help would be really appreciated.
Thanks,
dscon9128