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
- 16512 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
Triggers,VIEW,Procedures
What are the main differences you have observed between 7.x and 8.x version of datastage?
How do you generate sequence number in datastage?
Can you filter data in hashed file?
What is a merge?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What is the difference between validated and compiled in the datastage?
Describe the main features of datastage?
project Steps,hits, Project level HArd things,Solved methods?
What is the use of datastage director?
Describe link sort?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
how to sort two columns in single job in datastage.
What are the enhancements made in datastage 7.5 compare with 7.0?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
