Prepare for your Next Interview

• GeekInterview
• Knowledge base
• Interview Questions
• Tech FAQs

Column to row transformation

This is a discussion on Column to row transformation within the Data Warehousing forums, part of the Databases category; Is there any way we can do the column to row transformation through informatica? The reverse (row --> column) conversion is possible thru normalization transformation. NOTE : [This question was asked ...

Geeks Talk > Databases > Data Warehousing Column to row transformation

User Name Remember Me? Password

Register

FAQ

Members List

Calendar

Mark Forums Read

Thread Tools

Display Modes

#1 (permalink)   01-04-2007

JobHelper Expert Member   Join Date: Oct 2006 Posts: 690 Thanks: 0 Thanked 49 Times in 41 Posts

Column to row transformation Is there any way we can do the column to row transformation through informatica? The reverse (row --> column) conversion is possible thru normalization transformation. NOTE : [This question was asked by geetham]

Sponsored Links

#2 (permalink)   01-05-2007

manisha.sinha Junior Member   Join Date: Dec 2006 Location: London Posts: 20 Thanks: 0 Thanked 2 Times in 2 Posts

Re: Column to row transformation Hi If it occurs only twice , then we can use an aggregator and group by the repeating group and use first() and last() function. Does this help?

#3 (permalink)   01-18-2008

cme_prak Contributing Member   Join Date: Dec 2007 Location: INDIA Posts: 36 Thanks: 1 Thanked 6 Times in 6 Posts

Re: Column to row transformation Hi, Column to Row - Normalizer Transformatin Row to Column - Using an Expression and Aggregatoru can achieve that task. Please get back to us in case of queries. Thx Prakash

Geeks Talk > Databases > Data Warehousing

« Cardinalties check | I want to load 1,3,5 in one target and 2,4,6 in 2nd target »

Thread Tools

Show Printable Version Email this Page

Display Modes

Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Displaying data in a DataGrid for particular column	JobHelper	ASP.NET	1	02-26-2007 10:58 PM
Compare values of column in a table	JobHelper	SQL Server	1	12-13-2006 01:57 AM
Application source qualifier transformation	Lokesh M	Data Warehousing	0	12-08-2006 06:14 AM

All times are GMT -4. The time now is 04:39 PM.