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 |
EXPLAIN SCD
How many areas for files does datastage have?
there are two schemas x and y are there. some data is in x schema. i want to use that in y schema..how can i use? please give some possibilities
How a source file is populated?
in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.
in datastage scenario this is sourec data i want this traget? tell me please? source target ------- ------- Mohan,Prasad,Naresh Mohan Prasad Naresh
Terminate Activity
i have the source from Uk,north america how can i pass the data two tables based on the locations
what is sparse lookup?
How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?
I have 100 records how can I load at a time from the single time
What is a quality stage?