Abinitio - Do you know what a local lookup is?

GeekInterview.com > Interview Questions > Data Warehousing > Abinitio

Go To First | Previous Question | Next Question

Abinitio | Question 13 of 193

Do you know what a local lookup is?

Total Answers and Comments: 4

Last Update: December 26, 2006

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

July 10, 2005 11:58:12

Ashim Dutta

RE: Do you know what a local lookup is?

ashimdutta@yahoo.com
If your lookup file is a multifile and partioned/sorted on a particular key then local lookup function can be used ahead of lookup function call. This is local to a particular partition depending on the key.

Is this answer useful? Yes | No

September 08, 2005 13:59:58

sekhar

RE: Do you know what a local lookup is?

please explain with example

thanks
s

Is this answer useful? Yes | No

November 07, 2005 04:10:28

vpnreddy

Member Since: November 2005 Contribution: 1

RE: Do you know what a local lookup is?

Lookup File consists of data records which can be held in main memory. This makes the transform function to retrieve the records much faster than retirving from disk. It allows the transform component to process the data records of multiple files fastly.

VPN Reddy

Is this answer useful? Yes | No

December 26, 2006 04:36:54

mukund

RE: Do you know what a local lookup is?

Hi,

lookup_local funtion retrieves the first matching record from a partitioned multifile,which is partitioned on a particular key.

consider a lookup file "emp_detail" which is having the fields emp_id,emp_name,dept and is partitioned on emp_id.

use,

lookup_local("emp_detail","456A"),then u will get matching record for "456A" . where "456A" is the one of the emp_id.

hope this helps u

mukund

Is this answer useful? Yes | No

Go To Top