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
16745 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

What are routines in datastage? Enlist various types of routines.

1154

What are iconv and oconv?

1298

What is a ds designer?

1114

What is the roundrobin collector?

1150

Differentiate between Join, Merge and Lookup stage?

1141

What are the steps required to kill the job in Datastage?

1266

Highlight the main features of datastage?

1219

Describe routines in datastage? Enlist various types of routines.

1054

What is the method of removing duplicates, without the remove duplicate stage?

1079

Enlist various types of routines in datastage.

1328

Give an idea of system variables.

1090

What are the different kinds of views available in a datastage director?

1075

How to RD using transformer?

1476

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1795

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2247