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
- 16461 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 |
Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
What is merge stage?
HOW CAN YOU DO SCD2 IN DATA STAGE USING SEQUENTIAL FILES?
How can you find out whether datastage process is running or not in unix?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
HOW U CAN ABORT THE JOB IF THE DATA IS DUPLICATE?
HOW CAN U DO ERROR HANDLING IN DATA STAGE?
What is RCP?
What are the different type of jobs in datastage?
How can we read latest records in a text file named file1.txt using seq file stage only? file1 having 100 records in that 5 record sare latest records.How can we read that latest records?
input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?
What is the difference between Link collector and Funnel Stages?
Teradata 
