Tuesday, 25 February 2014

Informatica Common Errors :The Target Definition has more than one Transaction Control point connected to it

Error : The Target Definition has more than one Transaction Control point connected to it

Scenario :


Create a mapping with two streams( one with Transaction control and Second without Transaction control)..You will get  above error

Src1 - SQ1- EXP1- TGT1

Src2 - SQ2- Exp2-TC-TGT2

Reason :

Informatica processes transactional data row wise, hence,while using Transaction control for one of the targets to define the transaction point, Informatica fails to identify the transaction point for the other targets,This results in "The Target Definition has more than one Transaction Control point connected to it".

Solution :

You need to define Transaction Control transformation in other pipeline with property TC_CONTINUE_TRANSATION.

No comments:

Post a comment