DFLOAT DATATYPE MISMATCH
Posted: 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 .
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 .