Interested to Buy Any Domain ? << Click Here >> for more details...
why we use hash file for lookup?
- 5 Answers
- 17824 Views
- I also Faced
- E-Mail Answers
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 improve performance of data stage jobs?
What is difference between join, merge and lookup stage?
How to read multiple files using a single datastage job if files have the same metadata?
How do you find the number of rows in a sequential file?
What is the surrogate key? what is the use of surrogate key? how to Create surrogate key Generator in scd2 in 8.5?
What are the components of datastage?
What is Cleanup Resources and when do you use it?
Source flat file contains src --- 1 2 ' ' ' 18 we had 3 targets T1 T2 T3 -- -- -- 1 4 7 2 5 8 3 6 9 10 13 16 11 14 17 12 15 18 How can i get? **Using only datastage, but not unix or any other. I am expecting the answer soon.. Thanks in advance.
how can we create tables in datastage?
Thanks to all people who are posting their comments...
Unix command to view the data in a dataset
How To find the location of APT_confid file
Teradata 
