precision of double fields

jasper · Post by **jasper** » Mon Apr 10, 2006 2:41 am

Hi,
I'm working on data from multiple sources.(oracle/csv,..). I do some aggregations/transforms and load into an oracle db.
In the DB one of the fields is defined as number(14,6). Throughout the DS-job the data for this field is always a double, without any further specifiactions. This seems to round at 4 decimals.

Is there some kind of parameter we can use to make this 6? Or do I need to change to something else then double?

thompsonp · Post by **thompsonp** » Mon Apr 10, 2006 5:52 am

You could use a decimal(14,6).

When you do aggregations yo can specify the output as decimal otherwise it defaults to a double.