Friendz,
What transformation can be used to change rows into columns and vice versa in informatica. Plz explain me in detail.
Friendz,
What transformation can be used to change rows into columns and vice versa in informatica. Plz explain me in detail.
Re: Can any 1 help me.........
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....
Last edited by cme_prak; 07-12-2008 at 04:28 AM. Reason: For Alignment purpose
Prakash,
Nice info provided for the requestee...@!
And a nice quotation from you thru sign...
Sanghala
If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.
Posting Permissions
Reply With Quote