Pivot Table inside Informatica

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 20

After pivoting (Target Table)
ID Value A Value B
1 10 20

How can this be achieved inside informatica?

Questions by imkss

Showing Answers 1 - 3 of 3 Answers

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions