why we use hash file for lookup?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / jayam
Hash file is worked in key based . so lookup stage work on
comparasion of columns. so using hash file
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / bharath
Hash file is a refference table based on key fileds which
can provide fast access in lookups. Just to spped up the
lookup process we use hash files.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / varma
Hash files is the only way to do lookup .. It is key based
and ensures no duplicates are present on that key. It wont
give an error if you use OCI or DB2 stage as lookup but the
results will be wrong...
Is This Answer Correct ? | 1 Yes | 0 No |
how can we send even and odd records from a sequential file to two different targets
10 Answers IBM, iGate, TCS,
I have 5 different sources i want same records in 5 different targets Can you any body send me this question answer rathdsetl@gmail.com
how can find maximum salary by using Remove duplicate stage?
What are the areas of application?
How to get max salary of an organization using data stage stages........... can any body help me plz.......
what is the exact difference between dataset and fileset in datastage?
What are operators in datastage?
What is meta stage?
i/p 1,a,1000 2,b,2000 3,c,3000 i want to get o/p as o/p 1,a,3000 2,b,4000 3,c,5000 how it can be done on using datastage?
how can i abort the job if i get more than 100 errors in job log?
What could be a data source system?
What is RCP