what is the differeces between hash and modulus partition
methods

Answer Posted / venkata

Modulus is nothing but Modulus in Maths, so it can be
performed only on Numeric Data Fields, Hash can be used for
any kind of data fileds, it will assign similar values in
the partioning

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Differentiate between odbc and drs stage?

589


options available in sequence job to run,validate?

827


hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2422


Define Job control?

671


What are the areas of application?

655






What are some prerequisites for datastage?

610


In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1040


What are data elements?

651


Can we use target hash file as a lookup ?

2809


What is a folder? Difference types of stages?

622


Can you explain how could anyone drop the index before loading the data in target in datastage?

885


Why we use surrogate key?

695


Why do we use link partitioner and link collector in datastage?

679


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.

3495


explain about citrix scheduling tool in datastage

1808