Value rounded before is loaded in Oracle table field
Posted: Thu Jul 05, 2001 3:54 pm
Hi to the reader!
I have problem loading data in a Oracle table field.
The value from the source field of a text file contain a number, with 19 digits and I divide it by 100000000 before load it in a Decimal Oracle Table field with Length 19 and Scale 8. Executing this process I found in the Output field that
the value is rounded at the fourth Decimal and I need to hold the complete set of decimal number. Also debugging this process Ive checked that the output value of Transformer stage is already rounded.
Im running DS 4.0 on AIX. But ive tested this problem also on DS 4.1 on NT with Oracle 8.1.6.
Does anybody knows the reason?
Thanx
Giovanni Boccia
Sales Engineer
Direzione Industria e Servizi
Datamat - Enabling Your Future
Via Laurentina, 760
00143 Roma - Italy
I have problem loading data in a Oracle table field.
The value from the source field of a text file contain a number, with 19 digits and I divide it by 100000000 before load it in a Decimal Oracle Table field with Length 19 and Scale 8. Executing this process I found in the Output field that
the value is rounded at the fourth Decimal and I need to hold the complete set of decimal number. Also debugging this process Ive checked that the output value of Transformer stage is already rounded.
Im running DS 4.0 on AIX. But ive tested this problem also on DS 4.1 on NT with Oracle 8.1.6.
Does anybody knows the reason?
Thanx
Giovanni Boccia
Sales Engineer
Direzione Industria e Servizi
Datamat - Enabling Your Future
Via Laurentina, 760
00143 Roma - Italy