Working with Aggregator and Sorter Transformation

Working with Aggregator and Sorter Transformation

This tutorial shows the process of creating an Informatica PowerCenter mapping and workflow which pulls data from multiple data sources and use Aggregator and Sorter Transformation. Using a sorter transformation, you can sort data either in an ascending or descending order. And aggregator can be used to summarize data. 

Continue Reading

SCD Type 1 Implementation using Informatica PowerCenter

SCD Type 1 Implementation using Informatica PowerCenter

Unlike SCD Type 2, Slowly Changing Dimension Type 1 do not preserve any history versions of data. This methodology overwrites old data with new data, and therefore stores only the most current information. In this article lets discuss the step by step implementation of SCD Type 1 using Informatica PowerCenter.

Continue Reading

Informatica PowerCenter Repository Contents Upgrade

Informatica PowerCenter Repository Contents Upgrade

After an existing Informatica PowerCenter server binaries are upgraded to a higher version, we will have to upgrade the existing repository contents before we can enable the repository service and access the repository objects such as mappings, sessions, workflows etc... from the client tools. This article illustrates the step by step instructions for the upgrading the Informatica PowerCenter repository contents.

Continue Reading

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