The DS job is throwing warnings

[Nareshkurra]

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.

[ray.wurlod]

Don't specify float or dfloat, and always specify both precision and scale for Decimal data types.

[RAJARP]

You should specify both precision and scale for decimal data types in the oracle Enterprise, same as that of your Database.

[VijayDS]

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

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.