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?

Answers were Sorted based on User's Feedback



i having source like emptable,dept table and combined purpose using for the join stage but join st..

Answer / upputuri.vinod

DUDE JOIN STAGE USES THE HASH PARTITION STAGE..

Is This Answer Correct ?    7 Yes 0 No

i having source like emptable,dept table and combined purpose using for the join stage but join st..

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

More Data Stage Interview Questions

Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks

3 Answers   IBM,


while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance

2 Answers   MGL,


what is the Difference Between Datastage Server Edition and Parallel Edition?

2 Answers   Tech Mahindra,


Lookup constraints

0 Answers   CTS,


Highlight the main features of datastage?

0 Answers  


What is active and passive stage?

0 Answers  


count number of deptno in a emp table?

2 Answers   IBM,


hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

0 Answers  


job locking methods? How can we unlock the job?

3 Answers   IBM,


I/P --- ID Value 1 AB 2 ABC 3 ADE 4 A O/p --- ID Value 1 A 1 B 2 A 2 B 2 C 3 A 3 D 3 E 4 A

3 Answers   IBM,


How to clean the datastage repository?

0 Answers  


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

0 Answers  


Categories