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...

what is the best stage in datastage parller jobs to use full
out join and why

Answer Posted / swetha

use the join stage rather than using lookup and merge stages. join stage supports all the joins like inner join,leftouter join,right outer join,full outer join
lookup supports only inner,leftouter only

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have a few records just I want to store data in to targets cycling way how?

2414


Differentiate between datastage and informatica?

1249


how to add a new records into source?

2055


describe the Steps to confiure a Qlogic switch

2438


How can we improve the performance in datastage?

1146


How to Remove Duplicate using SQL?

1424


1.new record it will insert but changes of natural key is not present in taget i want to update (here key is composite natural key )can any one help this to explan how to do

2139


what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2872


How many types of views are there in a datastage director?

1340


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

857


What are the components of ascential data stage?

1240


im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

2257


Can you explain tagbatch restructure operator?

1215


How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3522


How do y read Sequential file from job control?

16078