Execution Order of Ports in an Expression Transformation?

Port Order

All Ports in Expression Transformation are executed from Top to Bottom and the order of the ports execution is as follows.



  1. Input ports. Informatica calculates all input ports first as they are not dependent on any other ports. So, we can create input ports in any order.
  2. Variable ports. Variable ports can reference input ports and variable ports, but not output ports. As variable ports can reference input ports, the Informatica calculates variable ports after input ports. Likewise, since variable port can reference other variables, the display order for variable ports is the same as the order in which the PowerCenter Server evaluates each variable.

  1. Output ports. As output ports can reference both input ports and variable ports, the Informatica evaluates output ports last. The display order for output ports does not matter, as output ports cannot reference other output ports. Output ports should appear at the bottom of the list of ports



No comments:

Post a Comment

Limitations of Pushdown Optimization - PDO

Limitations of Pushdown optimization. Source and Target and Lookups must be in same database server for full Pushdown. Expressions w...