Transaction Control Transformation in Informatica with Example

Transaction Control Transformation in Informatica , is a connected and active transformation  which let you control the commit and rollback of transactions for a set of input data.Example : you may define a transaction on group of employee rows ordered on a common key that is Department_no. Transaction Control Transformation help you control the commit and rollback on a group of data.Transaction can be control at below two level in Informatica Center. We can control Transaction at two levels: SESSION LEVEL : It can be done via setting session properties for Target. MAPPING LEVEL:It can be done by adding the transaction control transformation in mapping.We can add the  required condition in "Transaction control expression" Example : IIF(DEPT_NO >4 , TC_COMMIT_AFTER,TC_CONTINUE_TRANSACTION) One simple example of this transformation can be splitting of file depending upon certain field values. A well detailed example of Transaction Control Transformation can be found here. Hope you enjoyed this article, More details can be found at below site Must check : Please also check how to create Target Definition here. http://www.tecktricks.com/transaction-control-transformation-in-informatica-with-example/