Learn how can you use “Default values” in PowerCenter Transformation to your advantage.
All transformations use default values that determine how the Integration Service handles input null values and output transformation errors. Input, output, and input/output ports are created with a system default value that you can sometimes override with a user-defined default value.
Default values have different functions in different types of ports there is a lot more that you can do with default values.
The download file here contains mapping samples and a manual on using “default values” in a more effective way.