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
- 16743 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 difference between orabulk and bcp stages?
1)How to Duplicate Records Delete in Sequential file?
What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?
What could be a data source system?
State the difference between an operational datastage and a data warehouse?
What is difference between symmetric multiprocessing and massive parallel processing?
How do you run datastage job from the command line?
WHAT are unix quentios in datastage
What modeling tool do you use?
How to write a left outer join condition by using Transformer stage in server jobs? Could any one help me?
How many Nodes configuration file you used in your last project?
Name the different sorting methods in datastage.
Teradata 
