transformer - round off decimal values
Posted: Mon Jun 30, 2008 10:49 pm
I have given the metadata for a numeric field as (16,0) in the transformer, for input and output links. There are two output links with the same calculation. Once the calculation is done, the value is 12250.99.
One output link goes to an Aggregator whereas the other to a Sequential File. The Seq file gets populated with the value 12251 whereas the output from the Aggregator has the value 12250.99 itself. The metadata is numeric(16,0) in all stages.
Can someone please explain ?
One output link goes to an Aggregator whereas the other to a Sequential File. The Seq file gets populated with the value 12251 whereas the output from the Aggregator has the value 12250.99 itself. The metadata is numeric(16,0) in all stages.
Can someone please explain ?