Oracle EE Nullability & Decimal Warnings

[cdw]

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

[keshav0307]

its datastage warning, so you have to handle the null and conversion in datastage, rather then in the SQL.