How we can convert rows to columns in datastage?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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
Explain the importance of surrogate key in data warehousing?
how to call routines in stages?
What are the differences between datastage and informatica?
Define Merge?
Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.
How to get max salary of an organization using data stage stages........... can any body help me plz.......
What is the purpose of pivot stage?
What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?
Define oconv () and iconv () functions in datastage?
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.
what is the use of surogate key in datastage