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

if we take 2 tables(like emp and dept), we use join stage and
how to improve the performance?

Answer Posted / rajeshchunduri

in emp and dept tables key column is deptno so it is key
based and datatype for key column is int . At this time we
change partion tech from hash to modulus.



chunduri

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define ds designer?

1287


What is the purpose of pivot stage?

1179


what is the use of materialized view?

1580


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

4195


What are the types of hashed files in data stage

1114


Why do you need stage variables?

1188


What are the different kinds of views available in a datastage director?

1036


disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2471


What are system variables and sequencers in datastage

1122


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

2192


What is meta stage?

1189


table actions available in oracle connector?

1619


What are the types of containers in datastage?

1197


What are the primary usages of datastage tool?

1079


root tree will find which is server job and which is parallel job?

1977