Loop Transformation in PowerCenter
Posted by: Thomas Plamper
The Loop Begin and Loop End transformations enable PowerCenter users to repeatedly execute parts of their mapping logic.
Overview
The JTX_Loop transformation is a Java transformation, with which it is for the first time possible to implement loops in PowerCenter.All transformations between a Loop Begin and the corresponding Loop End transformations are executed again and again.The trail consists of 3 Examples
- The example Splitter determines the elements of a string and exports them row by row.
- The example Calc calculates a value based on an operator and the elements of a list.
- The example World analyzes a recursive data structure and displays the complete path to the root like oracles 'connect by prior'.
Features
Repeating one or more transformations numerous times for every input record.The last transformation(s) in the loop can hand over port values to the begin of the loop, e.g. for numerical approximations. The free trial version is fully functional but is limited in use for only one loop at any point in time per Integration Service.Also the free trial version is limited to be used for 30 days after download.- Currently available for PowerCenter 9.5.1 on all supported platforms (independent of hotfix version).
- The Loop Begin and Loop End transformations utilize the Java Runtime Environment used by PowerCenter.
- Detailed instructions for installation are included in the download.
- In general transaction boundaries will be discarded within the loop.
