Use Transformer Stage: Take stage variable, sv1 = sv1 : ' ' : D

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
16611 Views
Cognizant, UHG, I also Faced
E-Mail Answers

Answer Posted / reddymkl.dwh

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Define repository tables in datastage?

1164

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

781

Explain the situation where you have applied SCD in your project?

2041

What is the difference between informatica and datastage?

1235

If you want to use the same piece of code in different jobs, how will you achieve it?

1161

What is the difference between datastage and datastage tx?

1071

how to sort two columns in single job in datastage.

2907

What are sequencers?

1124

Triggers,VIEW,Procedures

1227

What is size of a transaction and an array means in a datastage?

1317

What is the process of killing a job in datastage?

1022

How do you import and export data into datastage?

1242

What is a ds designer?

1071

How can we improve performance of data stage jobs?

1019

describe the Steps to confiure a Qlogic switch

2385