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 will you move hashed file from one location to another location?
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
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
CHANGE CAPTURE
what is the difference between == and eq in UNIX shell scripting?
Describe the main features of datastage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
How a routine is called in datastage job?
Lookup constraints
Define Routines and their types?
Name the different sorting methods in datastage.
What is the difference between hashfile and sequential file?
How to perform incremental load in datastage?
What are the difference types of stages?
What are the some differences between 7.x and 8.x version of datastage?