Unable to load date into database

balu124 · Post by **balu124** » Tue Oct 09, 2007 3:28 am

Hi
we are usng the odbc stage to read the data from the source (oracle) database ,it's works fine.we are using odbc stage to load the data into orcle database.

But we got the error like this
ODBC_Enterprise_0: When checking operator: When binding output interface field "CUSTOMER_ID" to field "CUSTOMER_ID": Implicit conversion; from source type "dfloat" to result type "int32": Possible range/precision limitation

Can any one suggests the reason?

Maveric · Post by **Maveric** » Tue Oct 09, 2007 3:37 am

CUSTOMER_ID is declared as Float in DataStage and it is defined as Int in the database. that is the reason for the warning.

mcs@rajesh · Post by **mcs@rajesh** » Tue Oct 16, 2007 9:10 pm

HI balu
whenever we try to load data into the database it will consider datatypes on his own so based on that we need to change or modify the datatype...