table a contains 5 columns and table b contains 5 columns
how can i get 10 columns at target?
Answer Posted / akhi
It is Simple in join stage fullouterjoin technique we get
all 10 coloumns
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
What is the difference between passive stage and active stage?
project Steps,hits, Project level HArd things,Solved methods?
Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how
What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?
If you want to use a same piece of code in different jobs, how will you achieve this?
how many rows sorted in sort stage by default in server jobs
How can you write parallel routines in datastage PX?
Can we use target hash file as a lookup ?
What are the steps needed to create a simple basic datastage job?
tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise
If you want to use the same piece of code in different jobs, how will you achieve it?
What is staging variable?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
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
What is the command line function to import and export the ds jobs?