hash file concepts

sriec12 · Post by **sriec12** » Tue Feb 01, 2011 1:31 pm

1.When do u think, one should use ODBC stage for reference over hash file?
2.When is hash file not efficient?

thanks in advance

ray.wurlod · Post by **ray.wurlod** » Tue Feb 01, 2011 4:12 pm

Welcome is aboard.

U is the name of one of our posters (it's a Burmese name), so please use the correct spelling of "you".

Is this an interview question?

sriec12 · Post by **sriec12** » Wed Feb 02, 2011 10:22 am

@ray.wurlod,I am extremely sorry.

its not a interview questions. When i am interact with my friends, they asked me these questions. I tried in google search and IBM datastage documentation. I coun'dt find SUITABLE answer for these kind of questions?

Please kindly guide me in learning concepts.

ray.wurlod · Post by **ray.wurlod** » Wed Feb 02, 2011 3:08 pm

Why aren't your friends asking these questions?

I believe that, properly tuned, a hashed file will always be more efficient at performing lookups than any other method available to server jobs.