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
- 16452 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
CHANGE CAPTURE
What is the difference between odbc and drs stage?
What is the difference between passive stage and active stage?
How do you schedule or monitoring the job?
What are constraints and derivations?
Why do we use link partitioner and link collector in datastage?
What is the difference between informatica and datastage?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
How a server job can be converted to a parallel job?
How do you import and export data into datastage?
What are data elements?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
What is apt_config in datastage?
What are stage variables and constants?
How to Remove Duplicate using SQL?
