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
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Can you explain engine tier in information server?
What is a quality stage in datastage tool?
What is the flow of loading data into fact & dimensional tables?
Notification Activity
What are the main differences you have observed between 7.x and 8.x version of datastage?
What are the repository tables in datastage?
How can one find bugs in job sequence?
Name the different types of Lookups in Datastage?
What is a merge in datastage?
In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?
Explain the situation where you have applied SCD in your project?
On which Dimension Table you implemented SCD Type in your Project
What is staging variable?
describe the Steps to confiure a Qlogic switch