what is the differeces between hash and modulus partition
methods
Answer Posted / maruthi
HASH-KEY:- HERE DATA WILL BE POPULATED INSUCH A WAY THAT
REALATED DATA WILL STAY TOGETHER.
RANGE OF PRIMERY KER RECORDS WILL BE POPULATED TO ONE
PARTITION.
EG.)ALL PRIMARY RECORDS IN THIS MONTH WILL BE POPULATED TO
ON E PARTIOTION.
MODULUS:-PARTITIONED DATA WILL PROVIDE SOME INFORMATION.
IN THE SENSE CUSTOMERS RELATED TO ONE STORE WILL POPULATED
TO ONE PARTIOTION.
| Is This Answer Correct ? | 2 Yes | 10 No |
Post New Answer View All Answers
How do y read Sequential file from job control?
Define project in datastage?
How do you start developing a datastage project?
How to manage date conversion in Datastage?
How many Key we can define in remove duplicate stage?
what is ds administrator used for?
Define Routines and their types?
Does datastage support slowly changing dimensions ?
Terminate Activity
Difference between server jobs & parallel jobs?
What are the components of ascential data stage?
What is job control?
How we can covert server job to a parallel job?
How many areas for files does datastage have?
what is the use of skid in reporting?