transformer - round off decimal values

ktv · Post by **ktv** » 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 ?

ray.wurlod · Post by **ray.wurlod** » Mon Jun 30, 2008 11:03 pm

Welcome aboard. It's all about data types. Aggregator results are always dfloat, whereas Decimal(16,0) specifies no decimal places.