which is more expensive hash or modulus partitioning? when do
you use modulus partitioning?
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 difference between passive stage and active stage?
WHERE YOU USE UNIX COMMANDS AS A ETL DEVELOPER?
Define orabulk and bcp stages?
What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?
1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?
input Name Salay Sam 10 Sam 30 Sam 20 Ram 40 Ram 50 Output should be Name Salary Count Sam 10 3 Ram 40 2 get min salary and count of name . OutPut 2 Name Seq Sam 1 Sam 2 Sam 3 Ram 1 Ram 2
if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?
What is the different type of jobs in datastage?
Whats difference betweeen operational data stage (ods) and data warehouse?
What's the Main Function of the Staging area in DWH
How did you reconcile source with target?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?