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

i having source like emptable,dept table and combined
purpose using for the join stage but join stage which
partition techq will be prefored?
pls given the ans?

Answer Posted / san

When ever you want join the two files .. you need to do hash
partition using natural keys both sides. Otherwise the value
related keys will go into different partitions and while
join match will not occur properly.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you run datastage job from the command line?

1073


What is the importance of the exception activity in datastage?

1055


How do you import and export the datastage jobs?

1145


Which algorithm you used for your hashfile?

1163


which r the connectors used in san?

2175


What are the functionalities of link collector?

1071


how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

2356


Define meta stage?

1186


State the difference between an operational datastage and a data warehouse?

1120


What are the some differences between 7.x and 8.x version of datastage?

1244


Can you explain engine tier in information server?

1109


Whats difference betweeen operational data stage (ods) and data warehouse?

1101


How many types of hash files are there?

1162


How to perform incremental load in datastage?

1180


What is ibm datastage flow designer?

1126