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 / bharath

Hi,
Join stage is best 4 full outer join bcoz
lookup is RAM intensive where as join uses less memory.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Triggers,VIEW,Procedures

1221


What is difference between server jobs & parallel jobs?

1038


How you can fix the truncated data error in datastage?

1793


Give an idea of system variables.

1036


I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

1008


Explain the importance of surrogate key in data warehousing?

1191


Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4188


How and where you used hash file?

1174


Differentiate between odbc and drs stage?

1050


What is the differentiate between data file and descriptor file?

1363


Define data aggregation?

1102


What are the main differences you have observed between 7.x and 8.x version of datastage?

1089


Difference between server jobs & parallel jobs?

1078


Can you implement SCD2 using join, transformer and funnel stage?

1557


What is usage analysis in datastage?

1308