what is the differeces between hash and modulus partition
methods
Answer Posted / vijay
Hi this is Vijay
Modulus Hash
1. For numerics 1. For Numerics and characters
2. Datatype specific 2. Not Datatype spefic
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
How do you import and export the datastage jobs?
Why fact table is in normal form?
What is the difference between in process and inter process?
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
How you can fix the truncated data error in datastage?
How do you remove duplicate values in datastage?
What are stage variables and constants?
Have you used Unstructured data?
What is the difference between orabulk and bcp stages?
Define repository tables in datastage?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
Differentiate between operational datastage (ods) and data warehouse?
Differentiate between hash file and sequential file?
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 ?
Name the third party tools that can be used in datastage?