Informatica PowerCenter Constraint Based Load Ordering

Informatica PowerCenter Constraint Based Load Ordering

Constraint based loading technique is available in Informatica PowerCenter since couple of its prior versions. This PowerCenter feature will let you load multiple tables in a single session, which is having database level primary key - foreign key constraint or parent - child relation. In this article let's see what is needed to set up a session for constraint based loading.

Continue Reading

Design approach to Update Huge Tables Using Oracle MERGE

Design approach to Update Huge Tables Using Oracle MERGE

One of the issues 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.  We discussed about a design approach for this scenarion in one of our prior articles. Here in this updated article lets discuss a different approach to update Larger tables using Informatica Mapping.

Continue Reading

Informatica PowerCenter Repository BackUp and Restore

Informatica PowerCenter Repository BackUp and Restore

Informatica PowerCenter administrators regularly backup the repository contents to prevent any data loose due to hardware or software problems. When the repository contents is backed up, it saves all the contents as a binary file which includes all the repository objects such as mapping, sessions, workflows etc. These binary files can be used to restore the contents if in case of any failure. In this article lets discuss the step by step process to backup and restore a PowerCenter Repository.

Continue Reading

SCD Type 3 Implementation using Informatica PowerCenter

SCD Type 3 Implementation using Informatica PowerCenter

Unlike SCD Type 2, Slowly Changing Dimension Type 3 preserves only few history versions of data, most of the time 'Current' and Previous' versions. The 'Previous' version value will be stored into the  additional columns with in the same dimension record.  In this article lets discuss the step by step implementation of SCD Type 3 using Informatica PowerCenter.

Continue Reading

Informatica PowerCenter Installation Known Issues and Solution

Informatica PowerCenter Installation Known Issues and Solution

Since we published the article on informatica installation and configuration, we have been getting questions on different installation issues. So here we thought of writing an article with a consolidated list of issues faced during the installation.  This will be a live article and will be updated as and when we get new issues from the readers.

Continue Reading