Answer / ankit gosain

Hi All,

Hash partitioning is more expensive than modulus but it'll
give better performance as well.
The basic difference is, you can apply Modulus partitioning
for the number fields only while you can apply Hash
partitioning for Varchar and any type of field.

If you have more queries, you can mail me on
ankitgosain@gmail.com

Cheers,
Ankit :)

Answer / nish

has partitioning when distinct key fields are less.

Modulus when the key field are very few and numeric.

Modulus = x%y so the field ought to be numeric

I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.

2 Answers   TCS,

---

How many Key we can define in remove duplicate stage?

0 Answers   CTS,

---

i have source like deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like target1 deptno,sal 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformerstage

6 Answers  

---

how can you generate sequence number using only the sequential file stage?

3 Answers   TIAA CREF,

---

How to remove duplicates in transformer stage? in parallel mode

6 Answers   Syntel, TCS,

---

How to create environments and call them? What is the use defined variables?

2 Answers   HCL, ME,

---

What is difference between symmetric multiprocessing and massive parallel processing?

0 Answers  

---

What are the prerequisites for join stage

2 Answers  

---

How did you reconcile source with target?

3 Answers   HP,

---

What is the difference between operational data stage (ods) and data warehouse?

0 Answers  

---

Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??

1 Answers   IBM,

---

How to reverse the string using SQL?

0 Answers   CTS,

---