what is the differeces between hash and modulus partition
methods
Answer Posted / 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 |
Post New Answer View All Answers
What could be a data source system?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
How many types of stage?
What is the difference between account and directory options ?
How can you write parallel routines in datastage PX?
how to add a new records into source?
What is the difference between informatica and datastage?
Which warehouse using in your datawarehouse
What is a quality stage in datastage tool?
How to Remove Duplicate using SQL?
Name the different sorting methods in datastage.
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
How complex jobs are implemented in datstage to improve performance?
which r the connectors used in san?
Explain the importance of surrogate key in data warehousing?