what is the differeces between hash and modulus partition
methods
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 use of surogate key in datastage
Explain how a source file is populated?
What is the use of datastage director?
3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000
What are the prerequisites for join stage
Explain briefly scd type2 in datastage7.5x2(parallel)
What is data partitioning?
What is the version control how can i apply this in DataStage can any one tell me the anser
6) my sorce d1 d2 d1 d2 d1 d3 d2 d1 my target tartget 1 d1 2 d1 3 d1 4 d1 target2 1 d2 2 d2 3 d3 Target 3 1 d3 Can any body send me answer this is argent requierment
What is usage analysis in datastage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
what is snow flack schema?