Handling Null values in Talend and Pentaho
Handling Null values in Talend:
Make all the columns as Nullable in tMap
Now for the columns which are having Null values you can assign default values by writing ternary operator as shown in below screen-shot.
Handling Null values in Pentaho:
In Pentaho, to handle null values we have a component to provide a default value for the null values:
‘If field value is null’ is the component name.
You can assign default value for null values for the fields and also as per the datatypes.
You can configure the component as shown below: