If you use local variables in a mapping, use them in any transformation expression in the mapping. For example, if you use a complex tax calculation throughout a mapping, you might want to write the expression once and designate it as a variable. This increases performance since the
PowerCenter Integration Service
performs the calculation only once.
Local variables are useful when used with stored procedure expressions to capture multiple return values.