Prepare for your Next Interview
Can any 1 help me.........
This is a discussion on Can any 1 help me......... within the Data Warehousing forums, part of the Databases category; Friendz, What transformation can be used to change rows into columns and vice versa in informatica. Plz explain me in detail....
07-12-2008
|
|||
|
|||
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 
|
| The Following User Says Thank You to cme_prak For This Useful Post: | ||
|
07-22-2008
|
|||
|
|||
|
Re: Can any 1 help me.........
Prakash,
 Nice info provided for the requestee...@! And a nice quotation from you thru sign...
__________________
Sanghala www.dwforum.net - A Great resource for Data Warehousing Professionals If you are satisfied with my reply. Please click “Thanks” button which increases the reputation and can serve you better.
|
 |
|
«
Informatica
|
Data Integrator
»
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT -4. The time now is 01:37 AM.
Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved
