why we use hash file for lookup?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define Merge?

874


What steps should be taken to improve Datastage jobs?

641


What is difference between server jobs & parallel jobs?

623


how to export or import the jobs in .ISX file

717


Notification Activity

897






A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2029


What is size of a transaction and an array means in a datastage?

739


Differentiate between validated and Compiled in the Datastage?

642


How to perform incremental load in datastage?

668


how to abort the job its matain duplicates?

2103


How can one find bugs in job sequence?

785


what is the custome stage in datastage? how can we impliment that one? plz tell me

1910


What is the flow of loading data into fact & dimensional tables?

593


What is the difference between passive stage and active stage?

824


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

604