Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is the difference between passive stage and active stage?

1642


project Steps,hits, Project level HArd things,Solved methods?

2182


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

1600


What is developer responsibilities in UAT (user acceptance testing and Post implementation phase?

2157


If you want to use a same piece of code in different jobs, how will you achieve this?

1323


how many rows sorted in sort stage by default in server jobs

4048


How can you write parallel routines in datastage PX?

1065


Can we use target hash file as a lookup ?

3372


What are the steps needed to create a simple basic datastage job?

1303


tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

3181


If you want to use the same piece of code in different jobs, how will you achieve it?

1216


What is staging variable?

1153


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

855


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

3810


What is the command line function to import and export the ds jobs?

1189