Floating point decimal warning
Posted: Tue Sep 11, 2007 3:13 am
Hi,
I have designed a job with below user defined query on Oracle stage.
FROM APPADS.s_dim_store s LEFT OUTER JOIN
APPADS.s_dim_store_vers v
ON s.store_num= v.store_num FULL OUTER JOIN
APPADS.s_ipm_store i
ON v.store_num=i.SBUX_STORE_NUM
When I am reading the data from source tables I am getting below warning for s_dim_store table columns only.
Column BANQT_MERCH_NUM floating point decimal is not fully supported; adjusting the scale
In source oracle table column data type is Number and when I import the metadata for these colmns in Oracle stage it has taken default data type as Decimal[38,0].
One strange thing is in above queryIf I take the LEFT OUTER JOIN instead of FULL OUTER JOIN I am not getting the above warning.
Please let me know whether the warning is comming because of FULL OUTER JOIN instead of LEFT OUTER JOIN or any other reason.
Thanks for your help.
I have designed a job with below user defined query on Oracle stage.
FROM APPADS.s_dim_store s LEFT OUTER JOIN
APPADS.s_dim_store_vers v
ON s.store_num= v.store_num FULL OUTER JOIN
APPADS.s_ipm_store i
ON v.store_num=i.SBUX_STORE_NUM
When I am reading the data from source tables I am getting below warning for s_dim_store table columns only.
Column BANQT_MERCH_NUM floating point decimal is not fully supported; adjusting the scale
In source oracle table column data type is Number and when I import the metadata for these colmns in Oracle stage it has taken default data type as Decimal[38,0].
One strange thing is in above queryIf I take the LEFT OUTER JOIN instead of FULL OUTER JOIN I am not getting the above warning.
Please let me know whether the warning is comming because of FULL OUTER JOIN instead of LEFT OUTER JOIN or any other reason.
Thanks for your help.