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.
