Use Transformer Stage: Take two stage variable sv1= if sv2=DEPT

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.

Question Posted / reddymkl.dwh

3 Answers
16448 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

Please Help Members By Posting Answers For Below Questions

Is it possible to query a hash file?

1950

How to find value from a column in a dataset?

2146

what are the devoleper roles in real time? plz tell i am new to datastage....

2096

Define Data Stage?

1038

What is the difference between orabulk and bcp stages?

965

What is the flow of loading data into fact & dimensional tables?

1011

Difference between sequential file and data set?

1133

root tree will find which is server job and which is parallel job?

1881

What is the different type of jobs in datastage?

900

What is ibm datastage flow designer?

1079

what are the errors,warnings in datastage

2618

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1331

Define ds designer?

1214

Where do the datastage jobs get stored?

1149

How to reverse the string using SQL?

1424