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 to find value from a column in a dataset?
Notification Activity
Could anyone give brief explanation bout datastage admin
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Explain the situation where you have applied SCD in your project?
How many types of views are there in a datastage director?
What is difference between join, merge and lookup stage?
What is ibm datastage flow designer?
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
What is the process of killing a job in datastage?
What are the types of jobs we have in datastage?
whom do you report?
How do you import and export data into datastage?
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?
How you Implemented SCD Type 1 & Type 2 in your project?