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.
- 3 Answers
- 14982 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
Which warehouse using in your datawarehouse
How to Remove Duplicate using SQL?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
What is the use of datastage director?
What a datastage macro?
How many Key we can define in remove duplicate stage?
How a server job can be converted to a parallel job?
What could be a data source system?
whom do you report?
What are the steps required to kill the job in Datastage?
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
CHANGE CAPTURE
options available in sequence job to run,validate?
