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 |
by using dsjob..we can run only one job at a time?how can u run multiple jobs at a time in unix?
Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
what are the devoleper roles in real time? plz tell i am new to datastage....
What is the use of hoursfromtime() function in transformer stage in datastage?
what is meant by port ? what is the use of port ? what are the different type of ports and its usage
Define Data Stage?
IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?
In my source i have 10 records but i want 11 records in target. How can i acheive this in Server jobs.
WHAT are unix quentios in datastage
what is flow of project?
What are the different types of lookups in datastage?