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 have scenario like this seq file --> transformer --> sort
stage --> dataset
In this job which prtitioning technique you are using and
why???

Question Posted / jayaram.k

Answers were Sorted based on User's Feedback



I have scenario like this seq file --> transformer --> sort stage --> dataset In this j..

Answer / kiran

Hash partition or modulus partition. When using sort
operations always better to go for key partition techniques.

Is This Answer Correct ?    40 Yes 4 No

I have scenario like this seq file --> transformer --> sort stage --> dataset In this j..

Answer / ashok

we want write partition on integer type field like deptno
then go to modulus other wise go to hash is better in
performance wise

Is This Answer Correct ?    12 Yes 5 No

I have scenario like this seq file --> transformer --> sort stage --> dataset In this j..

Answer / bharath

Hash or Modulus partitioning
better go for hash becoz based on keyed partitioning is
best for the sort...

Is This Answer Correct ?    5 Yes 1 No

Post New Answer

More Data Stage Interview Questions

How can we run same job in 1 day 2 times

7 Answers   IBM,

Explain the importance of surrogate key in data warehousing?

0 Answers  

What is a datastage job?

0 Answers  

What are the stages in datastage?

0 Answers  

how do u catch bad rows from OCI stage? And what CLI stands for?

0 Answers  

how to retrive the max(sal),deptno,empno in datastage?

13 Answers   Polaris,

What can we do with datastage director?

0 Answers  

Triggers,VIEW,Procedures

0 Answers   CTS,

when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....

4 Answers   Target,

What are the different plug-ins stages used in your projects?

0 Answers  

How to read multiple files using a single datastage job if files have the same metadata?

0 Answers  

Is it possible to query a hash file?

0 Answers   IBM,

For more Data Stage Interview Questions Click Here
Categories