When you run an ODBC MySQL mapping that uses the MySQL ODBC 3.51 driver to write data to a MySQL target that contains a column with the Double data type, the mapping fails with the following error:
Column [A1_NUMBER_18_0] has scale greater than precision.
To resolve the error, upgrade to the MySQL ODBC 5.1 driver.
Note: Before you configure an ODBC connection in Data Integration, you must create a system Data Source Name (DSN).