Interested to Buy Any Domain ? << Click Here >> for more details...
what is the differeces between hash and modulus partition
methods
- 4 Answers
- 29077 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kiran
hai this is Kiran..,
If the key field is numeric use modules else hash
partition.as per performance tuning.
| Is This Answer Correct ? | 16 Yes | 1 No |
Answer / venkata
Modulus is nothing but Modulus in Maths, so it can be
performed only on Numeric Data Fields, Hash can be used for
any kind of data fileds, it will assign similar values in
the partioning
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / 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 |
what is the difference between the active datawarehouse and datawarehouse
my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage
Can you explain link buffering?
How can you write parallel routines in datastage PX?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
What is the use of hoursfromtime() function in transformer stage in datastage?
What are the stages in datastage?
A job is having only 2 stages I/p dataset and target table.Job is taking very long time to load 50 million records.How to improve performance of this job.
I have a source table with column name CITY having 100 records, I want target table with column name start with 'A' and 'B',remaining columns as reject outputs. how can achieve this by data stage?please help me?????
How do u set a default value to a column if the column value is NULL?
in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?
Describe the architecture of datastage?
Teradata 
