Use CHECKSUM Number to Make the LookUp Transformation Simple

Use CHECKSUM Number to Make the LookUp Transformation Simple

Lookup is one of the frequently used transformations in Informatica PowerCenter. This transformation is considered to be relatively simple, but at times this can become complex because of the amount of data to be cached, number of columns used in the lookup condition, checks on columns fetched from lookup table etc... In this article lets see how we can take care of couple of these issues using CHECKSUM number.

Continue Reading

ETL Design approach to Update Huge Tables

ETL Design approach to Update Huge Tables

One of the issue we come across during the ETL design is "Update Large Tables".  This is a very common ETL scenarion especially when you treat with large volume of data like loading an SCD Type 2 dimension table.  Here in this article lets discuss an approach to update Larger tables using Informatica Mapping.

Continue Reading

Design Approach to Ensure High Data Availability During Data Refresh

Design Approach to Ensure High Data Availability During Data Refresh

Many times we create snapshot tables and do build reporting on top of it. Refreshing the underlying table became difficult, if the report needs to be available 24x7 with out any down time. The refresh process can be a major design bottleneck, if in case the refresh takes hours. In this article lets discuss a design approach to make the target table data highly available.

Continue Reading