The solution to loop a workflow/mapping consists of the following components: A. Control table: This table has at a minimum two columns, one column stores the value based on which looping has to be performed which in our case is Dept_ID. The second column specifies if the row has been processed.
B. Parent workflow: This workflow consists of a mapping which determines if the there are any rows left in the control table that have to be processed. If yes then it calls the child workflow else it creates an indicator file which signals the end of the loop. C. Child workflow: This workflow contains the mapping which needs to be looped as per the requirement. The mapping also updates the control table to flag the row which it is currently processing.Both the workflow contains command task which call each other using pmcmd with NOWAIT parameter. The values in the control table have to be reset prior to process.You can download this listing as part of the Advanced Workflow Techniques.
FeaturesSolution to loop through a workflow. Sample mapping xml and workflow are provided as XML?s. DDL for control table is provided.Visio flows for the workflows are also provided using Informatica stencil.
Current Version: 1.0Release Date: 4/4/2011 System Requirements:
- Informatica PowerCenter 9.1 and 9.5