How to Pivot a table inside informatica? Allowing data spread across multiple rows to be inserted into a single row in a different table.Col A Col B A 10 B 20After pivoting (Target Table)ID Value A Value B1 10 20How can this be achieved inside informatica?

devidya

 Profile Answers by devidya Questions by devidya

• Sep 25th, 2008

Use a router to denormalize the data and then merge them using a union transfomation. I think this is one of the ways to do it. All the Best.

Answer Question  Select Best Answer