precision of double fields
Posted: 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?
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?