oracle decimal issue
Posted: Tue Apr 15, 2008 10:29 pm
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.
Please help in those cases. If it is already post please give me the thread.
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.