Can any 1 help me.........

[SS1211]

Friendz,
What transformation can be used to change rows into columns and vice versa in informatica. Plz explain me in detail.

[cme_prak]

Hi,

Column to Rows
------------------

Using Normalizer Transformation. We can convert Columns values to Row.


Rows to Columns
-------------------

logic
------

SRC------>AGG------>TGT

Using first function in aggregator. We can achieve that logic.

Please get back to me in case of queries.

Thx & regards,
Prakash Chandran
+91 99945 50500

Discussion is the way for gaining knowledge, Argument is the way for gaining enemies....

[sanghala]

Prakash,

Nice info provided for the requestee...@!

And a nice quotation from you thru sign...