Interested to Buy Any Domain ? << Click Here >> for more details...
why we use hash file for lookup?
- 5 Answers
- 17759 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 |
in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?
if ename='subbu' while running job the job should be abort how come?
How to initialize environment variables?
how to get the unique records on multiple columns by using sequential file stage only
what r the stages mostly used in realtime scenarios
Differentiate between Join, Merge and Lookup stage?
In a table 100 records are there after 50records job is aborted how can u insert all records in target table.
How to create user defined environment varibale(parameter)?
what is use of SDR function?
HOw Hash Partion Works Thank you in Advance i have doubts on Hash Partion TEch Could please give me the clear understandable notation example e_id,dept_no 1,10 2,10 3,20 4,20 5,30 6,40 i have TWo Nodes/Three Nodes My questions are: 1).if i select hash key as e_id how Hash partion will distribute the data in to two NOdes/three NOdes 2).if i select hash key as dept_no how Hash partion will distribute the data in to two NOdes/three NOdes sivakumar.katta7@gmail.com
Give example for FACTLESS FACT TABLE in real-time scenario.
if a column contains data like abc,aaa,xyz,pwe,xok,abc,xyz,abc,pwe,abc,pwe,xok,xyz,xxx,abc, roy,pwe,aaa,xxx,xyz,roy,xok.... how to send the unique data to one source and remaining data to another source????
Teradata 
