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

How to find value from a column in a dataset?

1769


Notification Activity

901


Could anyone give brief explanation bout datastage admin

1973


Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

1783


Explain the situation where you have applied SCD in your project?

1562






How many types of views are there in a datastage director?

834


What is difference between join, merge and lookup stage?

638


What is ibm datastage flow designer?

687


DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1037


What is the process of killing a job in datastage?

593


What are the types of jobs we have in datastage?

672


whom do you report?

1504


How do you import and export data into datastage?

703


if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1757


How you Implemented SCD Type 1 & Type 2 in your project?

3699