Transaction Control Transformation to Control Commit and Rollback in Your ETL

Johnson Cyriac Jan 29, 2014
Transaction Control Transformation to Control Commit and Rollback Transactions
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.

Informatica PowerCenter Design Best Practices and Guidelines

Johnson Cyriac Jan 20, 2014
Design Approach to Handle Late Arriving Dimensions and Late Arriving Facts
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.



About US Contact US Advertise Guest Post Terms and Conditions Privacy Policy Disclaimer

© 2012-2013 Data Intelligence Solution, All Rights Reserved
The contents in this site is copyrighted to Data intelligence Solution and may not be reproduced on other websites.