Interested to Buy Any Domain ? << Click Here >> for more details...
what is the differeces between hash and modulus partition
methods
- 4 Answers
- 29090 Views
- TCS, I also Faced
- E-Mail Answers
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 get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What is the command line function to import and export the ds jobs?
What are the different plug-ins stages used in your projects?
Could anyone give brief explanation bout datastage admin
Differentiate between datastage and datastage tx?
Explain connectivity between datastage with datasources?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
How do u convert the columns to rows in datastage?
What are the features of datastage flow designer?
Have you have ever worked in unix environment and why it is useful in datastage?
How to Remove Duplicate using SQL?
Can you implement SCD2 using join, transformer and funnel stage?
describe the Steps to confiure a Qlogic switch
What is the difference between datastage and datastage tx?
How we can covert server job to a parallel job?
