Home > Software > Data-Warehouse > DataStage
Interview Questions   Tutorials   Discussions   Programs   Discussion   

DataStage - What is the difference between hash and modulus partition methods?




1320
views
asked mar September 20, 2014 06:33 AM  

What is the difference between hash and modulus partition methods?


           

1 Answers



 
answered By vishnoiprem   0  
  • Hash and Modulus techniques are Key based partition techniques.
  • Hash and Modulus techniques are used for different purpose.
  • If Key column data type is textual then we use has partition technique for the job.
  • If Key column data type is numeric, we use modulus partition technique.
  • If one key column numeric and another text then also we use has partition technique.
  • if both the key columns are numeric data type then we use modulus partition technique.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert