Converting Vertical PIVOTing without using PIVOT stage in DataStage.
Ex:
DEPT_NO EMPNAME
10 Subhash
10 Suresh
10 sravs
Output:
DEPT_NO EMP1 EMP2 EMP3
10 subhash suresh sravs
2) How to implement Horizontal PIVOTing without using PIVOT stage.
Answer Posted / datastage4you
Use transformer stage to achieve the same
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the types of containers in datastage?
If you want to use a same piece of code in different jobs, how will you achieve this?
What are the job parameters?
How many types of views are there in a datastage director?
What are the features of datastage flow designer?
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)
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What is ibm datastage?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
Give an idea of system variables.
how to implement scd2 in datastage 7.5 with lookup stage
How can you write parallel routines in datastage PX?
What are the difference types of stages?
What is quality stage?
what is flow of project?