Interested to Buy Any Domain ? << Click Here >> for more details...
why we use hash file for lookup?
- 5 Answers
- 17794 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 |
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
in sequtial file 2 columns avaliable,iwant only one column load the target how do it.
What are the different database update actions available?
Can you filter data in hashed file?
How the ipc stage work?
What are sequencers?
IS FILE SET CAN SUPPORT I/P AND O/P LINK AT A TIME?
What is the difference between validated and compiled in the datastage?
how to handle null values using transformer stage?
how to sort two columns in single job in datastage.
What is difference between server jobs & parallel jobs?
What is exact difference between Parallel Jobs and server Jobs..
Teradata 
