How we can convert rows to columns in datastage?

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

More Data Stage Interview Questions

i have source like balance,drawtime 20000, 8.30 50000,10.20 3000,4.00 i want target like this balance,drawtime 20000, 20.30 50000,22.20 3000,16.00

2 Answers  


Explain the importance of surrogate key in data warehousing?

0 Answers  


how to call routines in stages?

3 Answers   ME,


What are the differences between datastage and informatica?

0 Answers  


Define Merge?

0 Answers  


Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.

2 Answers  


How to get max salary of an organization using data stage stages........... can any body help me plz.......

7 Answers   Cap Gemini,


What is the purpose of pivot stage?

0 Answers  


What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

1 Answers   TCS,


Define oconv () and iconv () functions in datastage?

0 Answers  


Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.

4 Answers   UHG,


what is the use of surogate key in datastage

0 Answers   TCS,


Categories