Skip navigation
Contact Us

Additional Information

Default values in Expression Transformation

Learn how can you use “Default values” in PowerCenter Transformation to your advantage.

Attributes:
Price: Free
Action:


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.


  • Informatica PowerCenter 9.1


Comments (0)