Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 16580 Views
- Cognizant, UHG, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Use transformer stage to achieve the same
| Is This Answer Correct ? | 2 Yes | 0 No |
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 |
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 |
what is the exact difference between dataset and fileset in datastage?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
Explain ibm infosphere information server and highlight its main features?
what is materialized view used datastage?
how to sort two columns in single job in datastage.
Where do the datastage jobs get stored?
Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the remaining sources.. How please design the job. Thanks.
Whats difference betweeen operational data stage (ods) and data warehouse?
Differentiate between Join, Merge and Lookup stage?
how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know
1.i have 5 jobs(1-5),i connect with each other,i want run from 3-5 only how? 2.how to schedual the job in datastage7.5 2? what is the deff bet grip and fgrep command? how do you cleanse the data in your project
What is difference between 8.1 , 8.5 and 9.1 ?
Teradata 
