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 / 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
How you Implemented SCD Type 1 & Type 2 in your project?
What is "fatal error/rdbms code 3996" error?
Enlist various types of routines in datastage.
What is difference between join, merge and lookup stage?
Name the command line functions to import and export the DS jobs?
what is use of SDR function?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
What is quality stage?
Describe routines in datastage? Enlist various types of routines.
What is staging variable?
Can we use target hash file as a lookup ?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
table actions available in oracle connector?
What is a quality stage in datastage tool?
How many types of sorting methods are available in datastage?