Skip navigation

Log In

Forgot your password?
Don’t have an account? Sign Up

Sign Up

Access our rich network of apps, trials, and services.

Start the registration process by entering your email address below.

Already have an account? Log In

Default values in Expression Transformation

Free download

Posted by: Aniruddh Abhishek

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.


For example,


  • Replacing Null Values.
  • Skipping Null Records.
  • Abort a session.
  • Replacing an error.


The download file here contains mapping samples and a manual on using “default values” in a more effective way.


  • PowerCenter version 9.1 and above


Comments Comments (0)