Data Transformation Table Creation Can't Identify Integers
I am trying to use Yellowfin as a simple data warehouse ETL manager. I'm trying to use the Data Transformation "Output to DB step", which provides the option of creating a table to output to if one does not already exist:
The problem is that this process is failing to identify integers. My input data has a primary key which is an integer but the auto-generated table instead has a decimal with only 6 digits of capacity:
Not only is this the wrong data format, but if my primary key grows to a 7th digit I'm going to start getting errors when I migrate data.
Yellowfin's auto-generated tables should have columns the same format as the input data set.
I am migrating data from MS SQL Server 2012 to MySQL.