How we can convert rows to columns in datastage?

Question Posted / hemanth.datastage

4 Answers
25288 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How we can convert rows to columns in datastage?..

Answer / krishna

hai vinod

this is krishna,when i try to use your method using copy &
funnel stages,its not working because when we are dividing
copy stage into sub copys after that when we are club in
funnel stage from cpy1 it was not supporting o/p link,it
support reject link too funnel

Is This Answer Correct ?

3 Yes

0 No

How we can convert rows to columns in datastage?..

Answer / rams

Using pivot stage

ex:-

name,ph1,ph2
ramu,9849,9948
raja,9987,9967
touch,9898,0909

in pivoi stage go to output>- columns

columnname derivation

name
phone PH1,PH2

TO GOT THE RESULT IS

o/p:-

name phone
ramu,9849
ramu 9948
raja,9987
raja,9967
touch,9898
touch,0909

Is This Answer Correct ?

7 Yes

6 No

How we can convert rows to columns in datastage?..

Answer / manohar palla

I am going to use tranformer and funnel stages to implement the
pivot functionality.

name ph1 ph2---> tranformer--->tf1 name ph1
| funnel---->o/p
|____>tf2 name ph2

tf1 and tf2 are the TWO links from transfomer..

in tf1 we have the name and ph1 where in tf2 name and ph2.

In funnel stage i am going to club the two links and send it
to o/p.

Thanks :)

Is This Answer Correct ?

2 Yes

2 No

How we can convert rows to columns in datastage?..

Answer / upputuri.vinod

Bro that's right I have another ans as-well..

I am going to use copy and funnel stages to implement the
pivot functionality.

name ph1 ph2---> copy--->cp1 name ph1
| funnel---->o/p
|____>cp2 name ph2

CP1 and CP2 are the TWO links from COPY..

in cp1 we have the name and ph1 where in cp2 name and ph2.

In funnel stage i am going to club the two links and send it
to o/p.

THE BENEFIT IN THIS IS WE CAN USE PIVOT UPTO 3250 ROWS
ONLY.. AFTER THAT IT WONT WORK..

SO WE CAN USE IT...

Is This Answer Correct ?

3 Yes

6 No

Post New Answer