NVL Function

Number of input and output field

Number of input field : One
Number of output field : One

This transformation function is used to provide a default value (as stated in the parameter) if the input field value is null or empty.