Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 3 Answers
- 16744 Views
- Cognizant, UHG, I also Faced
- E-Mail Answers
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 datastage sequences?
What is the project in datastage?
in oracle target stage when we use load option and when we use upsert option?
What is quality stage?
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
What is the purpose of pivot stage?
What is the difference between in process and inter process?
What are the different common services in datastage?
how to delete one row in target dataset
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
Differentiate between operational datastage (ods) and data warehouse?
Can you highlight the main features of ibm infosphere information server?
State the difference between an operational datastage and a data warehouse?
What are stage variables, derivations and constants?
how can we create rank using datastage?what is the meaning of rank?
