1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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

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

Can you explain players in datastage?

713

How to read multiple files using a single datastage job if files have the same metadata?

746

What are the difference types of stages?

635

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2037

Why do you need stage variables?

674




I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

558

What is the project in datastage?

675

What are some prerequisites for datastage?

623

what is the use of materialized view?

969

Different ways a project can be moved to production ?...example ….export-import and Version control.

1944

How many Key we can define in remove duplicate stage?

826

Can you explain kafka connector?

783

What is the importance of the exception activity in datastage?

632

How can we improve performance of data stage jobs?

622

I have a few records just I want to store data in to targets cycling way how?

1907