DFLOAT DATATYPE MISMATCH

devsonali · Post by **devsonali** » Thu Oct 04, 2012 3:36 pm

Hello All ,
I have an issue where I am trying to pull a decimal fields which loads as Float (when I import the metadata definition from the database ), however when i just try process the data to say peak stage for testing purposes I have the following error

Schema reconciliation detected a size mismatch for column X. When reading database column DFLOAT into column VARCHAR(min=0,max=15), truncation, loss of precision or data corruption can occur. (CC_DBSchemaRules::reportSizeMismatch, file CC_DBSchemaRules.cpp, line 1,692)

I did a search in the Forum here and found that this can be casted as decimal and that works well for me ,
However I have lots of other fields that are float data types when the table metadata is imported
I wanted to find if you guys know a way to process this data without writing user defined SQL (Select Cast )

I appreciate your time looking into this .

devsonali · Post by **devsonali** » Thu Oct 04, 2012 3:45 pm

I retried to just load the data as it is by choosing the Float datatype as such

It gave me

Schema reconciliation detected a size mismatch for column noofauditors. When reading database column DFLOAT into column SFLOAT, truncation, loss of precision or data corruption can occur. (CC_DBSchemaRules::reportSizeMismatch, file CC_DBSchemaRules.cpp, line 1,692)

Anybody faced something similar to this , please feel free to share your workarounds or Solutions

ray.wurlod · Post by **ray.wurlod** » Thu Oct 04, 2012 11:14 pm

The solution is to have your metadata match what's really out there.

I always do, so I've never encountered that particular message.