Oracle EE Nullability & Decimal Warnings
Posted: Tue Jul 21, 2009 11:34 pm
Hi,
While using Oracle EE Stage, I am facing the following errors:
1) Column CUST_SKEY floating point decimal is not fully supported; adjusting the scale.
2) Converting a nullable source to a non-nullable result;
a fatal runtime error could occur; use the modify operator to
specify a value to which the null should be converted.
Issue 2 is due to the usage of alias
I checked dsxchange for solutions on this. The post suggest using cast function for #1 and using NVL for #2.
However, even with both the options the warnings still persist.
The Field is defined as Number in the table
While importing into DS, it is taken as Decimal 38,10
I have used 'nvl(cast(ALL_CUST_SKEY_PROF as DECIMAL(38,10)),-1) CUST_SKEY' in the SQL. However, both warnings still persist
I have also tried with Decimal 38,0.
Am I missing something here?
Regards,
Bakul
While using Oracle EE Stage, I am facing the following errors:
1) Column CUST_SKEY floating point decimal is not fully supported; adjusting the scale.
2) Converting a nullable source to a non-nullable result;
a fatal runtime error could occur; use the modify operator to
specify a value to which the null should be converted.
Issue 2 is due to the usage of alias
I checked dsxchange for solutions on this. The post suggest using cast function for #1 and using NVL for #2.
However, even with both the options the warnings still persist.
The Field is defined as Number in the table
While importing into DS, it is taken as Decimal 38,10
I have used 'nvl(cast(ALL_CUST_SKEY_PROF as DECIMAL(38,10)),-1) CUST_SKEY' in the SQL. However, both warnings still persist
I have also tried with Decimal 38,0.
Am I missing something here?
Regards,
Bakul