datatype conversion

[mohanraj]

hi friends

I am new to datastage.I am facing some problems while transfering data from flat files to oracle oci .
The problem is my incoming data is suppose like this 0.00053 in flat files and when i want to put in OCI i am giving datatye as decimal with precision 1 and scale 5.But i am not getting output and it is telling that precision should be more than the decimal.But even after changing precision also it is not transfering into OCI.

What shall i have to do

Thanks in advance

raju

[ray.wurlod]

Welcome aboard. :D

You need to specify precision large enough to encompass all the digits in your number - at least (scale + 1).

When you imported the Oracle table definition, what were the precision and scale? What is the Oracle data type of the column in question?

[kumar_s]

In you given example 0.00053, length = 6 and scale = 5.

[us1aslam1us]

In you given example 0.00053, length = 6 and scale = 5.

Is it length=7 and scale=5 or length=6 and scale=5.

Sam

[ray.wurlod]

Precision 6 and scale 5 will allow numbers less than 10.00000. Precision 7 and scale 5 will allow numbers less than 100.00000.

[mohanraj]

hi to all

Thanks for your replies i got the answer

cheers..
raju