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 |
CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?
How and where you used hash file?
i want for the 3rd max sal using for the any stage but max sal is based on the deptno ? any body know this ans pls send this mail siva3me@gmail.com
i want job aborted after some records are loaded into output by using only sequential stage and dataset
Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks
What are sequencers?
Which algorithm you used for your hashfile?
Please Tell me..,I need some Complex Jobs in datastage as per in interview?how to tell and how to explain?please send as well as posiible please
by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?
What are constraints and derivations?
How do you import and export the datastage jobs?
what is materialized view used datastage?