Skip navigation

Log In

Forgot your password?
Don’t have an account? Sign Up

Sign Up

Access our rich network of apps, trials, and services.

Start the registration process by entering your email address below.

Already have an account? Log In

Mapping: Convert Rows To Columns

Free download

Posted by: Informatica Platform

This template describes a mapping in Informatica PowerCenter which helps to pivot data from multiple rows into columns in a single row.

Overview

This solution describes how to pivot data from the multiple rows into columns in a single row.

 

Source

CUSTOMER_IDPRODUCT_CATEGORYSALES_AMT
CUST_1CAT_A2000
CUST_1CAT_B3000
CUST_1CAT_C4000
CUST_2CAT_A8000
CUST_2CAT_C7000

 

Target

CUSTOMER_IDCATEGORY_A_AMTCATEGORY_B_AMTCATEGORY_C_AMT
CUST_1200030004000
CUST_28000
7000

 

There are a few different methods of building one record out of several. Often this can be accomplished by using an aggregator. Alternatively, an Expression variable logic can be utilized. This mapping template illustrates all the methods.

Key Features

Using Expression port variables allows for great flexibility on the condition on which the final record can be built.

Specifications

  • Informatica PowerCenter 9.1 and above.

Resources

Comments Comments (12)

Related