[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1786
  • Last Modified:

Transformation to transpose in informatica

We need to convert the name value pair data to column wise data.
Which transformation is used to transpose the data?
0
rajannagpal
Asked:
rajannagpal
1 Solution
 
kanemaCommented:
This is normally done with an Aggregator transformation.  You need to have your target already set up with the columns coming in. The data from the rows is denormalized into columns by putting a formula in the expression field of the aggregator transformation for each of the column names in your target table. These formulas are based on the incoming row data.
0
 
rajannagpalAuthor Commented:
Aggregator is used only for numeric values. We have to unpivot/transpose the character data coming as rows from source and populate into columns. Which is the right way to do this operation?
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now