Page 1 of 1

oracle decimal issue

Posted: Tue Apr 15, 2008 10:29 pm
by chvenkat.v
I am reading data from oracle table, one column having number(9) , but I am importing from oracle table definition thru plug-in it is reading like decimal 9 with 0 scale . job is running fine. But I log file I got three issues.

R_CDR: Column IN_CALLS_CNT floating point decimal is not fully supported; adjusting the scale.
R_CDR: When checking operator: When binding output interface field "IN_CALLS_CNT" to field "IN_CALLS_CNT": Implicit conversion from source type "decimal[38,10]" to result type "int32": Possible range/precision limitation.
S_PRS_DAY: When checking operator: When validating export schema: At field "IN_CALLS_CNT": "null_field" length (0) must match field's fixed width (14)

Please help in those cases. If it is already post please give me the thread.

:(

Posted: Tue Apr 15, 2008 11:31 pm
by John Smith
You have a data type issue so just do a search on decimal to integer conversion. Also do a search on null fields.

Posted: Wed Apr 16, 2008 7:12 am
by chvenkat.v
sorry can you pls give thread location

i am unable top search in the form


thnks

venkat

Posted: Wed Apr 16, 2008 7:17 am
by chulett
I got 22 matches doing an Exact search for "Possible range/precision limitation", how are you "unable" to do the same? :?