Inconsistent Numeric Output After Migrating Models Created Using Native dBase Data Sources
When you open a model that was created in an earlier version of Transformer and that model uses native dBase as the data source, unexpected numeric values may appear. This known migration issue relates to the fact that, beginning in Transformer Version 7.4, dBase data sources must be accessed through ODBC.
Steps to Avoid the Problem of Incorrect, Invalid, or Truncated Numeric Data
Review all columns in your native dBase models to identify which ones use numeric data types.
On the property sheet for each column that you identify, change the scale and decimal properties as required to generate the correct output.
Save the model and confirm that the numeric data appears correctly in Transformer Version 7.4.
Tip: You can instead manually edit the older MDL file. For example, change the column definition from Storage Default Scale 2 Size 12 Decimals 2 to read Storage Float64 Scale 0 Size 8 Decimals 0.
