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
- 16612 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 |
How to manage date conversion in Datastage?
What are the functionalities of link partitioner and link collector?
How did you reconcile source with target?
Explain the importance of surrogate key in data warehousing?
How to remove ctrl M or(^M) characters in file using Sequential File stage?
2 Answers Bank Of America, Satyam,
How to delete the data in dataset?types of deleting the data in dataset?
My source having following data as below, AB1 Aim2 Abnv5 1An8bx and my question is i need the Datastage job the following as in my target 000AB1 00Aim2 0Abnv5 1An8bx Please help me to achive this.
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?
What is PX?
options available in sequence job to run,validate?
How do u convert the columns to rows in datastage?
how to sort two columns in single job in datastage.
Teradata 
