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


Please Help Members By Posting Answers For Below Questions

Describe link sort?

636


What is the different type of jobs in datastage?

568


explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

1922


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


how do u catch bad rows from OCI stage? And what CLI stands for?

2277






What is the difference between passive stage and active stage?

812


i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2266


what is the custome stage in datastage? how can we impliment that one? plz tell me

1904


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2022


how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

1915


What are the different kinds of views available in a datastage director?

596


How many types of hash files are there?

608


which r the connectors used in san?

1785


What are the components of ascential data stage?

645


What is the difference between odbc and drs stage?

635