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

WHAT ARE THE STAGES U WILL USE IN IMPLEMENTING SCD2/DATE FIELD

8 Answers   L&T,

Define ds designer?

0 Answers  

What is the precedence of stage variables,derivations, and constraints?

0 Answers  

my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?

3 Answers   TCS,

how many datamarts we will use in real time project and when will use the datamart?pls send the replay early

2 Answers   Tech Mahindra,

Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises

1 Answers   TCS,

Hi guys, Design job sequence, we have 3 sources, in that 1st source in abort then only run the remaining sources.. How please design the job. Thanks.

2 Answers   IBM,

what is parameterset?

4 Answers   Wipro,

options available in sequence job to run,validate?

0 Answers   CTS,

how to sort two columns in single job in datastage.

1 Answers   TCS,

What is apt_config in datastage?

0 Answers  

How to find value from a column in a dataset?

0 Answers   TIAA CREF,

For more Data Stage Interview Questions Click Here
Categories