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
Differentiate between odbc and drs stage?
options available in sequence job to run,validate?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Define Job control?
What are the areas of application?
What are some prerequisites for datastage?
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?
What are data elements?
Can we use target hash file as a lookup ?
What is a folder? Difference types of stages?
Can you explain how could anyone drop the index before loading the data in target in datastage?
Why we use surrogate key?
Why do we use link partitioner and link collector in datastage?
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.
explain about citrix scheduling tool in datastage