Where Transaction Control Transformation is useful? Based on whether the condition is met, you can choose to either commit/roll back rows or continue processing data without changing the transaction boundaries. The Transaction Control transformation identifies the transactions based on transaction control condition defined in the transformation. The Transaction Control transformation is an active and connected transformation that commits or rolls back transactions (sets of rows) during a mapping run. What is a Transaction Control Transformation?
Each set is considered as a transaction and each set may have varying number of records.
If the department ID is used to group the records, then there will be 12 different sets of employee data. The number of rows in each transaction can vary.įor example in an employee table there is data of 100 employees belonging to 12 different departments.
What is a Transaction?Ī Transaction is a set of rows grouped together based on a common key field such as Department ID of employees or transaction date of a product. What is the difference in the implementation of Transaction control in Powercenter vs Cloud? 1.
0 kommentar(er)
