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

What are the different type of jobs in datastage?

0 Answers  

what are the types of nodes

4 Answers   HCL, TCS,

Question 4) source target c1 c1 c2 c3 c2 c4 c4 c5 c3 c6 c7 c4 c5 c6 c7 Singal Source and Singal Target only subash,

3 Answers   TCS,

which memory is used by lookup and join

5 Answers   IBM,

In Sequential file, how can i split a column into two, and that column contains string datatype. For Example, i have column of string datatype as subedar khaja. Now i want get output as separately with subedar in one column and khaja in second column. How? Coula anybody, solve it?

2 Answers   Polaris,

how will u design file watch jobs?

2 Answers  

what is the difference between the active datawarehouse and datawarehouse

1 Answers   TCS,

How a routine is called in datastage job?

0 Answers  

What is a range lookup?

2 Answers   IBM,

What is exact difference between Parallel Jobs and server Jobs..

7 Answers   IBM,

I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?

4 Answers   CSC,

If the job aborted in a sequencer, how can we start that from the previews successful job.

1 Answers   SLK Software,

For more Data Stage Interview Questions Click Here
Categories