Compare Data Type

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.