How can I convert colums into rows

[b]question asked by visitor altay[/b]

in datastage how can i convert colums into rows?

in table i have:
-----------------------------------------
id name tel
-----------------------------------------
1 xxxx 222 22 22
2 xxxx 333 33 33
3 xxxx 444 44 44
4 yyyy 555 55 55
5 yyyy 666 66 66
6 zzzzz 777 77 77

in result table i want to see: -----------------------------------------------------
name tel1 tel2 tel3
-----------------------------------------------------
xxxxx 222 22 22 333 33 33 444 44 44
yyyyy 555 55 55 666 66 66
zzzzzz 777 77 77

Hi Friend. In Data Integrator ETL Tool, there is one transformation to change col to rows named as pivot. In Oracle there is one concept called Project to change columns to rows.
In DI u will get the desired output by using this transformation

you use normalizer transformation

From mukul_07

Here is my code

ALTER PROCEDURE [dbo].[PR_RETAILER_SELECTE_W_RETAILERINVOICE]

-- Add the parameters for the stored procedure here

--(
--
-- @sRTL_ID int,
-- @iErrorCode int OUTPUT
--)
--
--AS
--
--declare @current varchar(250)
--
--set @current = ''


--SELECT
--@current = ltrim(rtrim(@current)) + + ltrim(rtrim(INV_ID)+',')

--FROM
--[dbo].[RETAILERINVOICE]

--where

--[RTL_ID] = @sRTL_ID

--select @current

--END

[QUOTE=Geek_Guest;8359][b]question asked by visitor altay[/b]

in datastage how can i convert colums into rows?

in table i have:
-----------------------------------------
id name tel
-----------------------------------------
1 xxxx 222 22 22
2 xxxx 333 33 33
3 xxxx 444 44 44
4 yyyy 555 55 55
5 yyyy 666 66 66
6 zzzzz 777 77 77

in result table i want to see: -----------------------------------------------------
name tel1 tel2 tel3
-----------------------------------------------------
xxxxx 222 22 22 333 33 33 444 44 44
yyyyy 555 55 55 666 66 66
zzzzzz 777 77 77[/QUOTE]



U can get this one using the Normaliser transformation In informatica

u can get this one using normaliser transformation in informatica.