I have scenario like this seq file --> transformer --> sort stage -->

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

3 Answers
22116 Views
CTS, IBM, I also Faced
E-Mail Answers

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

Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.

6 Answers IBM,

Name the different sorting methods in datastage.

0 Answers

Tell me the syntax of Configuration file?

1 Answers

eno ename esal acct1 acct2 amount1 amount2 100 suresh 10000 sbi1 sbi2 1000 2000 this is our sourse data i would loke to disply like this eno ename esal acct amount 100 suresh 10000 sbi1 1000 100 suresh 10000 sbi2 2000

2 Answers HCL,

What is the use of datastage designer?

0 Answers

I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?

1 Answers CGI,

How to use Environment variable's in datastage?(use of process)

1 Answers CSC,

Define repository tables in datastage?

0 Answers

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

0 Answers

1.what is stagearea?what is stage variable? 2.this is my source source:id, name target:id, name 100, murty 100,madan we have three duplicate records for the id column,how can we getthe source record? 100,madan 100,saran

1 Answers HCL,

source has 2 fields like COMPANY LOCATION IBM HYD TCS BAN IBM CHE HCL HYD TCS CHE IBM BAN HCL BAN HCL CHE LIKE THIS....... AND I WILL GET THE OUTPUT LIKE THIS.... Company loc count TCS HYD 3 BAN CHE IBM HYD 3 BAN CHE HCL HYD 3 BAN CHE PLZ SEND ME ANSWER FOR THIS QUESTION..........

3 Answers Patni,

Why fact table is in normal form?

0 Answers

For more Data Stage Interview Questions Click Here