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

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

when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....

4 Answers   Target,

which cache supports connected & un connected Lookup

1 Answers   Wipro,

can any one tell me how to install datastage 8.1 in windows xp with wizard

2 Answers  

i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME

3 Answers   Cap Gemini,

How do you get log info into a file?

1 Answers  




i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage

6 Answers  

What is the difference between passive stage and active stage?

0 Answers  

2.how u run your rotines in unix? what is job sequencer? if i have 4 jobs i would like to run 2 jobs in server(using job jobsequencer)and remaining 2 in parallel?how can i run?

1 Answers  

there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities

2 Answers   Wipro,

Tell me Wt main advantage of Stage varibles? Project level hints?

4 Answers   Hexaware,

what is .dsx files

3 Answers   IBM,

What is the difference between validated and compiled in the datastage?

0 Answers  

For more Data Stage Interview Questions Click Here
Categories