Working with Router Transformation and Aggregator Transformation

Working with Router Transformation and Aggregator 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 Router Transformation. Router transformation can be used to split the data into different groups. And aggregator can be used to summarize data.

Continue Reading

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