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
Warnings during reading from Oracle table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 12
- Joined: Mon Nov 27, 2006 1:28 am
-
- Premium Member
- Posts: 1255
- Joined: Wed Feb 02, 2005 11:54 am
- Location: United States of America
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.
Then, the best way to read the table would be by importing the right meta-data using the DS Manager.
Whale.
Anything that won't sell, I don't want to invent. Its sale is proof of utility, and utility is success.
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
Author: Thomas A. Edison 1847-1931, American Inventor, Entrepreneur, Founder of GE
-
- Participant
- Posts: 12
- Joined: Mon Nov 27, 2006 1:28 am
[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
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
-
- Participant
- Posts: 56
- Joined: Mon Oct 16, 2006 7:32 am