I am using Oracle and Teradata to compare data using the wizard. Automatic mapping does not occur when a field value is numeric and mapping to an integer. How do I automate?
You might have to perform a "cleanse" task within the Automation flow, which calls up the Transformation & Cleanse engine to change the datatype to something more comparable.
This assumes you have TDP Professional version, BTW.