Transaction Control Transformation to Control Commit and Rollback in Your ETL

Transaction Control Transformation to Control Commit and Rollback in Your ETL

In a typical Informatica PowerCenter workflow data is committed to the target table after a predefined number of rows are processed into target, which is specified in the session properties. But there are scenarios in which you need more control on the commits and rollbacks.  In this article, lets see how we can achieve this using Transaction Control Transformation.

Continue Reading

Informatica PowerCenter Design Best Practices and Guidelines

Informatica PowerCenter Design Best Practices and Guidelines

A high-level systematic ETL design will help to build efficient and flexible ETL processes. So special care should be given in the design phase of your project. In following we will be covering the key points one should keep in mind while designing an ETL process. The following recommendations can be integrated into your ETL design and development processes to simplify the effort and improve the overall quality of the finished product.

Continue Reading