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
- 7668 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 difference between Datastage 7.5 and 7.0?
What are the different common services in datastage?
if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????
What is the use of datastage director?
Distinguish between informatica & datastage. Which one would you choose and why?
where we use config file as parameter ?
What is the flow of loading data into fact & dimensional tables?
what are fact tables and dimension tables? give example assuming one table.
what is the difference between the active datawarehouse and datawarehouse
Whats difference betweeen operational data stage (ods) and data warehouse?
I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?
Explain the scenarios where sequential file stage runs in parallel?
Teradata 
