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 a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?
i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me i don't need "_"ex nnnxx this type i want
I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What is the precedence of stage variables,derivations, and constraints?
Nls stands for what in datastage?
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
What is exact difference between Parallel Jobs and server Jobs..
what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?
AGGREGATOR default datatype
How to reverse the string using unix?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)