DSXchange

Hi All,
I am Reading the data from an Oracle9i table using Oracle enterprise stage using PX. In PX I have defined thedata type as BigInt(13). But while reading the fields from the table for attribute "STG_25B_PK (Number(13) in oracle table)", I am getting warnings like

"Column STG_25B_PK floating point decimal is not fully supported; adjusting the scale."
and
"oesR_STAGE_D0275_25B: When checking operator: When binding output interface field "DUMMY_COL" to field "DUMMY_COL": Implicit conversion from source type "decimal[38,10]" to result type "int32": Possible range/precision limitation."

When I am defining the data type as decimal(13,0) it is showing like

"oesR_STAGE_D0275_25B: When checking operator: When binding output interface field "STG_25B_PK" to field "STG_25B_PK": Implicit conversion from source type "decimal[38,10]" to result type "decimal[13,0]": Possible range/precision limitation."

When I am defining the data type as decimal(13,0) it is showing like

"oesR_STAGE_D0275_25B,0: Column STG_25B_PK floating point decimal is not fully supported; adjusting the scale."

Kindly give some suggestions how to avoid the warnings.

Thanks id advance.

Regards,
Prasanta

Are you deliberately changing the datatypes and lengths? Or are you not aware of importing the meta-data from the manager. If the latter is the case.

Then, the best way to read the table would be by importing the right meta-data using the DS Manager.

Whale.

[Prasanta]:-

In Oracle table it si Number(13). I am importing the metadata from manager, and it is coming as Decimal(13). Still then the warnings are:-

I) oesR_STAGE_D0275_25B: Column STG_25B_PK floating point decimal is not fully supported; adjusting the scale.

and
II) oesR_STAGE_D0275_26B: When checking operator: When binding output interface field "STG_26B_PK" to field "STG_26B_PK": Implicit conversion from source type "decimal[38,10]" to result type "decimal[13,0]": Possible range/precision limitation.


And also I have pasted all possible combinatios....

Any updates/suggestions pl..

Regards,
Prasanta

Can you try reading the numeric value to varchar 13 and then convert it back to integer