[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!