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
What is the project in datastage?
What are routines in datastage?
How many types of sorting methods are available in datastage?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
Enlist various types of routines in datastage.
Describe link sort?
To see hidden files in LINIX?
What is the difference between an operational datastage and a data warehouse?
Different ways a project can be moved to production ?...example ….export-import and Version control.
What is data partitioning?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
In Datastage, how you can fix the truncated data error?
What is difference between server jobs & parallel jobs?
What is the difference between server job and parallel jobs?
Differentiate between data file and descriptor file?