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

  1. Categories >> Software >> Data Warehouse >> Data Stage
  2. Suggest New Category

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?

Question Posted / siva3me

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

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

0 Answers  

Can you highlight the main features of ibm infosphere information server?

0 Answers  

Lookup constraints

0 Answers   CTS,

what is the difference between == and eq in UNIX shell scripting?

0 Answers   CTS,

How can one find bugs in job sequence?

0 Answers  

what about data stage requirement

1 Answers  

can we see the data in fixed width file? how can u change the datatype of fixed width files?

1 Answers   Infosys,

Differentiate between validated and Compiled in the Datastage?

0 Answers  

WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR PROJECT?

2 Answers   GE,

table actions available in oracle connector?

0 Answers   CTS,

What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

1 Answers   TCS,

What is use Array size in datastage

0 Answers  

For more Data Stage Interview Questions Click Here
Categories