Learning Informatica PowerCenter 10.x - Second Edition

Using variable ports

If you are performing the same operation multiple times in a transformation, consider calculating the value in a variable port and use the variable port value multiple times in the transformation. Suppose you need to convert the first name and last name to uppercase, concatenate them, and need to cut part of the data. In place of using the UPPER function every time, use the variable port to convert data to uppercase and use the variable port to perform other operations. This way, you save time of performing the save operation multiple times.