Aggregator stage warning message : Implicit conversion
Posted: Tue May 19, 2009 9:54 am
Job design:
dataset 1
dataset 2 --> Funnel --> Aggregator --> Dataset3.
I am doing a sum on source field "Sales_amt" decimal(38,10) not null to an output field "Sales_amt" of decimal(38,10) not null using Agregator stage. the output finally gets loaded into Oracle Target with datatype "Number" [no precision]. I am getting following warning messages in Aggregator:
1.When checking operator: When binding output interface field "Sales_amt" to field "Sales_amt": Implicit conversion from source type "dfloat" to result type "decimal[38,10]": Possible range/precision limitation.
2.When checking operator: When binding output interface field "Sales_amt" to field "Sales_amt": 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.
Some of the trouble shoot I did was, for warning #2, changing the input and output field to null from not null in Aggregator stage to get rid of message two, even though my both input and outputs are not null.
for warning #1, change the output to 'double' in aggegator stage. But, while loading into Oracle table with data type as "number" will still need to convert the double back to decimal[38,10].
Could some one pls help with this to get rid of these messages?..
Thank you.
dataset 1
dataset 2 --> Funnel --> Aggregator --> Dataset3.
I am doing a sum on source field "Sales_amt" decimal(38,10) not null to an output field "Sales_amt" of decimal(38,10) not null using Agregator stage. the output finally gets loaded into Oracle Target with datatype "Number" [no precision]. I am getting following warning messages in Aggregator:
1.When checking operator: When binding output interface field "Sales_amt" to field "Sales_amt": Implicit conversion from source type "dfloat" to result type "decimal[38,10]": Possible range/precision limitation.
2.When checking operator: When binding output interface field "Sales_amt" to field "Sales_amt": 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.
Some of the trouble shoot I did was, for warning #2, changing the input and output field to null from not null in Aggregator stage to get rid of message two, even though my both input and outputs are not null.
for warning #1, change the output to 'double' in aggegator stage. But, while loading into Oracle table with data type as "number" will still need to convert the double back to decimal[38,10].
Could some one pls help with this to get rid of these messages?..
Thank you.