Interested to Buy Any Domain ? << Click Here >> for more details...
How we can convert rows to columns in datastage?
- 4 Answers
- 25112 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
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
On which interface you will be working as a developer?
How to clean the datastage repository?
How do you schedule or monitoring the job?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is the sortmerge collector?
What is the precedence of stage variables,derivations, and constraints?
How to RD using transformer?
what is flow of project?
Explain how a source file is populated?
which r the connectors used in san?
Describe stream connector?
What is the difference between datastage and informatica?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
How and where you used hash file?
