The DS job is throwing warnings while fetching the data fromsource table
Please find the warning below
table_name,0: Column Column_name floating point decimal is not fully supported; adjusting the scale.
The source table has just around 85000 records, where as the time taken to fetch the records is more than 10 minuts due to this warning.
Please suggest if any thing that we can improove.
The DS job is throwing warnings
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 21
- Joined: Mon Aug 04, 2008 8:34 am
- Location: Guntur
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: The DS job is throwing warnings
Hi Naresh,
Use cast function in SQL query and then change the datatype column to Decimal with scale. Same Decimal and scale to be mentioned in the SQL statement.
Eg:
cast(ColumnName as number(38,12)) as ColumnName
Use cast function in SQL query and then change the datatype column to Decimal with scale. Same Decimal and scale to be mentioned in the SQL statement.
Eg:
cast(ColumnName as number(38,12)) as ColumnName
Nareshkurra wrote:The DS job is throwing warnings while fetching the data fromsource table
Please find the warning below
table_name,0: Column Column_name floating point decimal is not fully supported; adjusting the scale.
The source table has just around 85000 records, where as the time taken to fetch the records is more than 10 minuts due to this warning.
Please suggest if any thing that we can improove.
Thanks
Vijay
Vijay