why we use hash file for lookup?

Answers were Sorted based on User's Feedback



why we use hash file for lookup?..

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

why we use hash file for lookup?..

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

why we use hash file for lookup?..

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

why we use hash file for lookup?..

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

why we use hash file for lookup?..

Answer / kiran

Hash file Give Performance

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More Data Stage Interview Questions

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

2 Answers   TCS,


how can find maximum salary by using Remove duplicate stage?

5 Answers   IBM,


What are the areas of application?

0 Answers  


How to get max salary of an organization using data stage stages........... can any body help me plz.......

7 Answers   Cap Gemini,






what is the exact difference between dataset and fileset in datastage?

5 Answers   TCS,


What are operators in datastage?

1 Answers  


What is meta stage?

0 Answers  


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?

5 Answers   HSBC,


how can i abort the job if i get more than 100 errors in job log?

6 Answers   Accenture,


What could be a data source system?

0 Answers  


What is RCP

5 Answers   CGI, CTS,


Categories