The mapping task will give you the status of the mapping execution as general output. You can define a workflow variable and assign it to the general output section to get the mapping status.

The main use case for this option is to route the flow to two different path based on the mapping execution status. Let’s see an example below.

The below workflow is processing an inbound file. The mapping task will execute the mapping m_01_process_inbound_file and the execution status is available in OUTPUT >> General Outputs section >> “Is Successful“. This will return true (1) or false (0).

You can define a workflow variable with a Boolean datatype and assign it to “Is Successful” field to get the status. You can also define and assign three more variables to get the statistics from the mappings, the number of source/target/error rows processed by the mapping.

Once this is done, You can configure an exclusive gateway to check the mapping status and route the flow based on the status. In this example, we are sending two different emails in case of success and failure. The exclusive gateway will validate the workflow variable v_map_01_status which holds the mapping status, if its success (true) it will route to the success path and if its failed (false) it will route to the failure path.

Have any questions? or need help with this topic, please do reach out to me at kvtinformatica@gmail.com. Don’t forget to follow my Youtube channel and FB page, Lets stay connected and learn together.