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

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

can any one tell me how to install datastage 8.1 in windows xp with wizard

2 Answers  


how can or from where we can get reference data in scd type2 implementation?

2 Answers   JPMorgan Chase,


how can we send even and odd records from a sequential file to two different targets

10 Answers   IBM, iGate, TCS,


what is factless fact table?

3 Answers   IBM,


What is datastage?

0 Answers  


INPUT file 'A' contains: 1 2 3 4 5 6 7 8 9 10 input file 'B' contains: 6 7 8 9 10 11 12 13 14 15 Output file 'X' contains: 1 2 3 4 5 Output file 'Y' contains: 6 7 8 9 10 Output file 'Z' contains: 11 12 13 14 15 How can we implement this in a single ds job?

11 Answers   CTS,


How many types of sorting methods are available in datastage?

0 Answers  


1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

0 Answers   Polaris,


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

0 Answers  


i have a project manager round on sat this week can you post what are the main question i have to check.if you have any idea regular question on project pls send me. thanks in advance

2 Answers   IBM,


I am getting input value like X = Iconv(ā€œ31 DEC 1967ā€,ā€Dā€)? What is the X value? How it is? At what situation we r used Iconv(),Oconv().

1 Answers   Amdocs, TCS,


how can we create rank using datastage?what is the meaning of rank?

0 Answers   IBM,


Categories