Home » Developer & Programmer » Warehouse Builder » HOW to convert rows into column in ODI (oracle 11g)
HOW to convert rows into column in ODI [message #568474] Fri, 12 October 2012 02:19 Go to next message
zeeshan007
Messages: 20
Registered: July 2012
Location: Pakistan
Junior Member
Hi dear,

I want to move data from source to target table.
my source table have column PARTS and have values

---------- SOURCE TABLE -----------
PARTS VALUES
A 200
B 450
C 600

I want to convert Rows into column in ODI like
--------- TARGET TABLE -----------
A B C
200 450 600

Regards
Zeeshan Mehboob




Re: HOW to convert rows into column in ODI [message #568482 is a reply to message #568474] Fri, 12 October 2012 02:48 Go to previous message
zeeshan007
Messages: 20
Registered: July 2012
Location: Pakistan
Junior Member
Further more

I have created source and target tables and mapped the columns.

but when i moved data ..
ODI throws an error than

"single-row subquery returns more than one row"

regards
Previous Topic: Dimensional Design Question
Next Topic: 1 dimension and 2 fact table -cartesian join
Goto Forum:
  


Current Time: Fri Nov 28 17:12:53 CST 2014

Total time taken to generate the page: 0.17045 seconds