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?
Who is Participating?
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.
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?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.