Hi,
I have a ETL job that hit below error,
Column YEAR_MONTH floating point decimal is not fully supported; adjusting the scale.
Column YEAR_MONTH has been modified in sql as TO_NUMBER(TO_CHAR(COMBR.ETL_RUN_DATE,'YYYYMM'))
And the target column datatype has changed to integer or numeric still hitting the same error.
Need your help in this.
Thanks in advance.
Numeric data type
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 76
- Joined: Mon Mar 05, 2007 9:26 pm
- Location: Malaysia
-
- Participant
- Posts: 148
- Joined: Thu Apr 10, 2008 12:47 am
-
- Participant
- Posts: 76
- Joined: Mon Mar 05, 2007 9:26 pm
- Location: Malaysia
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
as you are using to_number() and ETL_RUN_DATE = 20101024 which is not number(6). try using
Code: Select all
cast(TO_CHAR(COMBR.ETL_RUN_DATE,'YYYYMM'), number(6))
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.