how to convert rows into columns
- 2 Answers
- 11027 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swetha
BY using Pivot stage convert rows into columns in
datastage.If we want to change in informatica we use
normalizer transformation.
| Is This Answer Correct ? | 11 Yes | 6 No |
Name the third party tools that can be used in datastage?
i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?
what is the diff b/w switch and filter stage in datastage
Is there any possibility to generate alphanumeric surrogate key?
What is the difference between validated and compiled in the datastage?
I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3
What is difference between server jobs & parallel jobs?
What are the benefits of datastage?
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 are transforms and what is the differenece between routines and transforms?
CAN ANY ONE TELL ME THE ARCHITECTURE OF DATASTAGE CLEARLY....
I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?
Teradata 
