Interested to Buy Any Domain ? << Click Here >> for more details...
How we can convert rows to columns in datastage?
- 4 Answers
- 25059 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rams
Using pivot stage
ex:-
name,ph1,ph2
ramu,9849,9948
raja,9987,9967
touch,9898,0909
in pivoi stage go to output>- columns
columnname derivation
name
phone PH1,PH2
TO GOT THE RESULT IS
o/p:-
name phone
ramu,9849
ramu 9948
raja,9987
raja,9967
touch,9898
touch,0909
| Is This Answer Correct ? | 7 Yes | 6 No |
Post New Answer View All Answers
Difference between in process and inter process?
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?
What is difference between symmetric multiprocessing and massive parallel processing?
What is the difference between informatica and datastage?
Lookup constraints
What is the different type of jobs in datastage?
Different ways a project can be moved to production ?...example ….export-import and Version control.
what is the use of surogate key in datastage
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?
what are the devoleper roles in real time? plz tell i am new to datastage....
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
AGGREGATOR default datatype
