How we can convert rows to columns in datastage?
Answer Posted / 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 |
Post New Answer View All Answers
Why we use surrogate key?
What is the purpose of interprocessor stage in server jobs?
Differentiate between data file and descriptor file?
What is the purpose of pivot stage and types of containers in datastage
What are datastage sequences?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
How do you import and export data into datastage?
What are the job parameters?
Difference between in process and inter process?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
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 are the types of jobs we have in datastage?
Enlist various types of routines in datastage.
Differentiate between datastage and datastage tx?
Nls stands for what in datastage?