which is more expensive hash or modulus partitioning? when do
you use modulus partitioning?
- 2 Answers
- 7115 Views
- TIAA CREF, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How a server job can be converted to a parallel job?
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
1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.
What is the purpose of interprocessor stage in server jobs?
How many areas for files does datastage have?
What is the use of datastage designer?
sed,awk,head
What are the job parameters?
What are the areas of application?
What are the functionalities of link partitioner?
What are the types of containers and how to create them?
If you want to use a same piece of code in different jobs, how will you achieve this?
What is ds designer?
explain about citrix scheduling tool in datastage
Different ways a project can be moved to production ?...example ….export-import and Version control.
