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
Could anyone give brief explanation bout datastage admin
How do y read Sequential file from job control?
Demonstrate experience in maintaining quality process standards?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What are the functionalities of link collector?
what are the devoleper roles in real time? plz tell i am new to datastage....
How do you generate sequence number in datastage?
What are the difference types of stages?
What are the stages in datastage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
How do you reject records in a transformer?
Where do the datastage jobs get stored?
What is difference between join, merge and lookup stage?
Where do you see different stages in the designer?
What is the difference between hashfile and sequential file?