Getting warning when doing calculations in OCI stage

[parag.s.27]

I am using the OCI stage as aninput source for one of my job.

I have to do a calculation on two date fields and take the difference of dates in years. Finally I have to apply a floor function on it. So the final code in query is : -

Code: Select all

FLOOR((MONTHS_BETWEEN(QED.QUOTE_DATE, IP.BIRTH_DATE)/12)) AS "CUST_QUOTE_AGE_DATE"

.

I have defined this column in the OCI stage as Decimal(38,10) but it is giving me a warning as

Code: Select all

Oracle_Enterprise_0: Column CUST_QUOTE_AGE_DATE floating point decimal is not fully supported; adjusting the scale.

I also tried defining the column in OCI stage as Decimal(38) only. But still I am getting this warning.

Can someone please suggest, what datatype should I define for it and what should be its precision and scale

[iDomz]

floor returns integer as far as I know.

[parag.s.27]

floor returns integer as far as I know.

If that is so, then it should not give warnings while I am reading it as a Decimal type.

But its giving me that warning