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
- 7642 Views
- TIAA CREF, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Define Job control?
What are routines in datastage? Enlist various types of routines.
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Distinguish between informatica & datastage. Which one would you choose and why?
Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2
What steps should be taken to improve Datastage jobs?
What are the different type of jobs in datastage?
What are transforms and what is the differenece between routines and transforms?
EXPLAIN SCD
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
How many types of stage?
Explain usage analysis in datastage?
What are the differences between datastage and informatica?
What is ds designer?
What is merge stage?
