Use transformer stage to achieve the same

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 / datastage4you

3 Answers
16727 Views
Cognizant, UHG, I also Faced
E-Mail Answers

Answer Posted / datastage4you

Use transformer stage to achieve the same

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Notification Activity

1455

What are the repository tables in datastage?

1348

What are the some differences between 7.x and 8.x version of datastage?

1303

Define Routines and their types?

1255

What are the various kinds of the hash file?

1192

What are the different type of jobs in datastage?

1081

What is meta stage?

1238

Differentiate between datastage and informatica?

1243

What is the difference between in process and inter process?

1197

how can we create rank using datastage?what is the meaning of rank?

8845

What is the difference between account and directory options ?

1231

Triggers,VIEW,Procedures

1260

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

2288

What can we do with datastage director?

1289

Explain how a source file is populated?

1410