DSXchange

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?

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

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...