Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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 ?    4 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 to configure databases through datastage

2 Answers  


where we use config file as parameter ?

1 Answers   IBM,


how to retrive the max(sal),deptno,empno in datastage?

13 Answers   Polaris,


i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

0 Answers  


If you want to use a same piece of code in different jobs, how will you achieve this?

0 Answers  






what is the Difference Between Datastage Server Edition and Parallel Edition?

2 Answers   Tech Mahindra,


how does work server jobs?

1 Answers  


State the difference between an operational datastage and a data warehouse?

0 Answers  


how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

0 Answers   JPMorgan Chase,


how to define satge variables in transformer stage

2 Answers  


What modeling tool do you use?

6 Answers   HP,


What is job control?

0 Answers  






Categories