[Informatica] ERROR | Target has more than one Transaction Control point connected to it.

While using Transaction Control transformation, we might face a issue when we encounter an error similar to this.

The Target Definition Dummy has more than one Transaction Control point connected to it.
...there are data flow validation errors.
Parsing mapping test_mapping...
...parsing completed with no errors.

 
******** Mapping test_mapping is INVALID ********

The mapping validation fails and does not allow you to run the workflow.

Problem Description:
The way Transaction control transformation treats data is row by row. Hence the properties TC_CONTINUE_TRANSACTION,TC_COMMIT_BEFORE,TC_COMMIT_AFTER,TC_ROLLBACK_BEFORE,TC_ROLLBACK_AFTER.

However, in case multiple pipelines in your mapping, Informatioca fails to identify Transaction Point for other targtes. Hence resulting in data folow validation error.

Solution:
The souluion is to either remove the multiple pipelines and implement the whole logic in a single pipeline.
Or, have a Transaction Control Transformation in each pipeline. If can define the transaction point as TC_CONTINUE_TRANSACTION for other flows.

Hope this helps!