Interested to Buy Any Domain ? << Click Here >> for more details...
which is more expensive hash or modulus partitioning? when do
you use modulus partitioning?
- 2 Answers
- 7880 Views
- TIAA CREF, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 :)
| Is This Answer Correct ? | 4 Yes | 0 No |
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
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the precedence of stage variables,derivations, and constraints?
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..........
State the difference between an operational datastage and a data warehouse?
What is RCP
Wat is isolation level and when do u use them?
if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?
In one project how many shared containers are created?
What is "fatal error/rdbms code 3996" error?
What is the Difference Between DataStage 7.5 version and 8.1 Version?
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
How can we do null handling in sequential files
hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...
Teradata 
