Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / hari
Hash partitioning
method is the key
based partition
method... And lookup
wich also compare and
retrieve the data
based on key
column... So by using
hash method wil
increase performance
in lookup...
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Can you define merge?
Why we use surrogate key?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
Can you explain how could anyone drop the index before loading the data in target in datastage?
Explain ibm infosphere information server and highlight its main features?
Name the different sorting methods in datastage.
what is the use of materialized view?
What are the different kinds of views available in a datastage director?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
How to reverse the string using SQL?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
What is data partitioning?
How the ipc stage work?
Triggers,VIEW,Procedures
