How we can convert rows to columns in datastage?
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
What are iconv and oconv?
What are the types of views in datastage director?
how to abort the job its matain duplicates?
What is the project in datastage?
How can you write parallel routines in datastage PX?
Name the command line functions to import and export the DS jobs?
Nls stands for what in datastage?
Give an idea of system variables.
Can you explain how could anyone drop the index before loading the data in target in datastage?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
I have a few records just I want to store data in to targets cycling way how?
What are the important features of datastage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
Differentiate between datastage and informatica?