DSXchange

Posted: **Sun Dec 18, 2011 5:55 am**

Using Row Generator, is it possible to get the below 5 rows with 2 columns as output.(columns are comma separated for illustration)


col1,col2
----------
DUMMY,ABC
DUMMY,ZSE
DUMMY,HYT
DUMMY,OIU 
DUMMY,LKP

All are fixed and there is no logic in deriving.

Thanks

Posted: **Wed Dec 21, 2011 12:30 am**

Yes. I have accomplished that using Row Generator.
One more way i can think of is using Oracle enterprise stage by ytilizing dual table.


select 'DUMMY' as DUMMY,"ABC" as VALUE from dual
UNION
select 'DUMMY' as DUMMY,"ZSE" as VALUE from dual
....
....
...

Thanks

Logic for one row to multiple rows