Friendz,
What transformation can be used to change rows into columns and vice versa in informatica. Plz explain me in detail.
Printable View
Friendz,
What transformation can be used to change rows into columns and vice versa in informatica. Plz explain me in detail.
Hi,
Column to Rows
------------------
Using Normalizer Transformation. We can convert Columns values to Row.
Rows to Columns
-------------------
logic
------
SRC------>AGG------>TGT
Using [b]first[/b] 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....
Prakash, :)
Nice info provided for the requestee...@!
And a nice quotation from you thru sign...