Adding (Int) did not resolve the issue - please see image. I tried to set the precision to 0, but for some reason it won't allow me to do so. I've also tried this with data type double in case null values are creating problems, but come up with the same errors.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.