Hi All ,
I have a scenario where my data from source looks like this [a1^v1][a2^v2][a3^v3]
and the output should be as below
You can use the Normalizer transformation, but it needs a finite number of occurs (new rows) it does not support n number of occurs/rows.
I do not think you can do this with any built in PowerCenter transformation or combination of transformations.
You can try using the Java transformation perhaps to do this.