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
- 15478 Views
- Cognizant, UHG, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Use transformer stage to achieve the same
| Is This Answer Correct ? | 2 Yes | 0 No |
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 |
Use Transformer Stage:
Take stage variable,
sv1 = sv1 : ' ' : DSLink.EMPNAME
Derivation : Trim(sv1, ' ','L')
U will get output.
| Is This Answer Correct ? | 0 Yes | 2 No |
what is the use of materialized view?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
How do you register plug-ins?
how to sort two columns in single job in datastage.
what is the Difference Between Datastage Server Edition and Parallel Edition?
How do you schedule or monitoring the job?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
0 Answers Alpharithm Technologies,
what is usage of datastage with materialized views
What are the features of datastage flow designer?
What a datastage macro?
What is meta stage?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
Teradata 
