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
Can you filter data in hashed file?
If you want to use the same piece of code in different jobs, how will you achieve it?
What is difference between symmetric multiprocessing and massive parallel processing?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What is the difference between datastage and informatica?
Why do we use exception activity in Datastage?
What is the project in datastage?
Can we use target hash file as a lookup ?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
in oracle target stage when we use load option and when we use upsert option?
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 to sort two columns in single job in datastage.
What is quality stage?
If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?