Ashim Dutta

• Jul 10th, 2005

 

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.

sekhar

• Sep 8th, 2005

 

please explain with example 
 
thanks  
s

vpnreddy

 Profile Answers by vpnreddy 

• Nov 7th, 2005

 

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

mukund

• Dec 26th, 2006

 

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