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

Can you implement SCD2 using join, transformer and funnel stage?

1519

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

2000

Explain Quality stage?

1109

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2343

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2032

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1528

What is a datastage job?

985

What are routines in datastage?

1295

What are stage variables, derivations and constants?

1184

What are the partitioning techniques available in link partitioner?

2250

What are orabulk and bcp stages?

1085

how to delete one row in target dataset

3083

Highlight the main features of datastage?

1113

What are the areas of application?

1109

how do u catch bad rows from OCI stage? And what CLI stands for?

2762