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
- 15480 Views
- Cognizant, UHG, I also Faced
- E-Mail Answers
Answer Posted / reddymkl.dwh
Use Transformer Stage:
Take two stage variable
sv1= if sv2=DEPT_NO then sv1 : ' ' : EMPNAME
sv2= DEPT_NO
Derivation : Trim(sv1, ' ','L')
U will get output.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Is possible to create skid in dim,fact tables?
What is the difference between the local container and shared container?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
project Steps,hits, Project level HArd things,Solved methods?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What are the types of containers?
What is the different type of jobs in datastage?
What is a ds designer?
table actions available in oracle connector?
what are the devoleper roles in real time? plz tell i am new to datastage....
What all are the different way to run a job?
What is the project in datastage?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
How to find value from a column in a dataset?
