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
- 15479 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 is use of SDR function?
Can you explain repository tables in datastage?
Triggers,VIEW,Procedures
Why do we use exception activity in Datastage?
What are routines in datastage? Enlist various types of routines.
Could anyone give brief explanation bout datastage admin
How many types of views are there in a datastage director?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
Terminate Activity
Difference between in process and inter process?
What is the command line function to import and export the ds jobs?
which r the connectors used in san?
how to write server Routine coding?
Why we use surrogate key?
How do you start developing a datastage project?
