Data Integration Solutions: Transformations

Rank Transformation to find TOP or BOTTOM Ranked Data Sets

SCD Type 4, a Solution for Rapidly Changing Dimension

Rank Transformation can be used to rank record sets and return records with the largest or smallest rank with in a group based on a port value. You can also use a Rank transformation to return the strings at the top or the bottom of an ordered data. In this article lets discuss a practical application of Informatica Power Center Rank Transformation.

Build Reusable Code in Informatica PowerCenter Using Mapplets

Reusability is a great feature in Informatica PowerCenter which can be used by developers. Its general purpose is to reduce unnecessary coding which ultimately reduces development time and increases supportability. In this article lets see how we can build mapplet in Informatica PowerCenter to make your code reusable.

Data Manipulation Using Update Strategy in Informatica PowerCenter

It is obvious that we need data manipulation such as Insert, Update and Delete in an ETL job, Informatica PowerCenter provides Update Strategy transformation to handle any such data manipulation operations. Lets understand Update Strategy Transformation in detail.

Stored Procedure Transformation to Leverage the Power of Database Scripts

A Stored Procedure is an important tool for populating and maintaining databases. Since stored procedures allow greater flexibility than SQL statements, database developers and programmers use stored procedures for various tasks within databases. Informatica PowerCenter provides Stored Procedure Transformation to leverage the power of Database Scripting. In this article lets see it in more in detail about how to use Stored Procedure Transformation.

Sequence Generator Transformation for Unique Key Generation

The Sequence Generator transformation generates numeric values in a sequential order. Use the Sequence Generator to create unique primary key values, replace missing primary keys, or cycle through a sequential range of numbers. In this tutorial lets see a practical implementation of Sequence Generator transformation.

Working with Router Transformation and Aggregator Transformation

Working with Aggregator and Souter 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.

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.

Working with Joiner Transformation and Rank Transformation

character encoding in Informatica Joiner Transformation and Rank Transformation

This tutorial shows the process of creating an Informatica PowerCenter mapping and workflow which pulls data from Flat File data sources and uses Joiner Transformation and Rank Transformation to build a consolidated sales report.
Continue Reading

Popular Posts

Random Posts

Posts Being Viewed