Null value in non-Nullable column for an Integer field

Four Stars

Null value in non-Nullable column for an Integer field

I am relatively new so please consider this if there is a obvious answer.  
I have a simple job for which I am trying to move data from a MSSQL database to Redshift.  In particular I am getting an error indicating tMSSqlInput_10 Null value in non-Nullable column.  The flow is tMSSqlinput -> tmap -> tRedshiftoutput  
Within the tmap I am checking for 

 

row12.ClientInstitutionId = 0 ? 0 : row12.ClientInstitutionId

 

The system will not let me check for null (row12.ClientInstitutionId == null) as it appears that Java needs me to check for zero instead.  My thinking being that I can let the value zero go to redshift if the source data is null (or zero), otherwise send over the value

 

I am ammending this a bit as I have replaced the tmap and tredshift components with the tlogrow component.  I still get the same error message.  

 

 

Four Stars

Re: Null value in non-Nullable column for an Integer field

I answered my own question.  The database schema had changed and I did not change that schema on my connection 

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog