Available in...
Open Studio for Big Data
Open Studio for Data Integration
Open Studio for ESB
The Iterate connection can be used to loop on files contained in a directory, on rows contained in a file or on DB entries.
A component can be the target of only one Iterate connection. The Iterate connection is mainly to be connected to the start component of a flow (in a subJob).
Some components such as the tFileList component are meant to be connected through an iterate connection with the next component. For how to set an Iterate connection, see Iterate connection settings.
Note: The name of the Iterate
connection is read-only unlike other types of connections.
Warning: Note that the globalMap is
error-prone in parallel execution. Be cautious when using
globalMap.put("key","value")
and globalMap.get("key")
to create your own global variables and then retrieve
their values in your Jobs, especially after an Iterate connection with the parallel execution option enabled.