Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: 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 / subbuchamala

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

Answers were Sorted based on User's Feedback

Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subha..

Answer / datastage4you

Use transformer stage to achieve the same

Is This Answer Correct ?

2 Yes

0 No

Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subha..

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

Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subha..

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

More Data Stage Interview Questions

I am running a job with 1000 records.. If the job gots aborted after loading 400 records into target... In this case i want to load the records in the target with 401 record... How will we do it??? This scenario is not for sequence job it's only in the job Ex: Seq file--> Trans--> Dataset..

9 Answers Cognizant, IBM, TCS, Virtusa,

1.What is a delta record? How you will read it? 2.What are the different types of sorting?

0 Answers EDS,

specify data stage strength?

1 Answers

country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?

3 Answers Wipro,

What is exact difference between Parallel Jobs and server Jobs..

7 Answers IBM,

in oracle target stage when we use load option and when we use upsert option?

0 Answers

I am having two tables called MASTER and DETAIL. I want to insert records to both tables. But one condition is that whenever the insert for MASTER table is success then only the records will inserted into the DETAIL table, otherwise abort the job. How can u design this job?

1 Answers TCS,

How you Implemented SCD Type 1 & Type 2 in your project?

0 Answers

A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls

7 Answers TCS,

what is use of SDR function?

0 Answers CGI,

how to delete one row in target dataset

0 Answers Satyam,

HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?

1 Answers IBM,

For more Data Stage Interview Questions Click Here