For example, if an input string port is called DEPT_NAME and you want to replace null values with the string ‘UNKNOWN DEPT’, you could set the default value to ‘UNKNOWN DEPT’. Depending on the transformation, the Integration Service passes ‘UNKNOWN DEPT’ to an expression or variable within the transformation or to the next transformation in the data flow.
For example, the Integration Service replaces all null values in a port with the string ‘UNKNOWN DEPT.’
DEPT_NAME REPLACED VALUE
NULL UNKNOWN DEPT