Convert Multiple Rows into Single Row.

Here we have scenario like this.


Source:

                                                         

Above is the my source table/data, now I want to convert that data into row wise. As shown in below target table.

Target:

Step1:

Import source and target tables into informatica designer.

Step2:

Create new mapping and drag this source and target into that mapping.

Step3:

Create expression transformation and configure that as shown in below.

And click on OK.

Step4:

Create an Aggregate transformation and configure as shown in below.

Click on OK.


Srep5:

Please find the below is the complete mapping screenshot.

Now you can create the session and run the workflow.

If you want mapping XML please mail to me/ do comment here.


You may interested in convert one row into multiple.
One row to multiple