Local lookup is specifically designed for multi-file lookup scenarios where each partition has its own lookup file that is local to that partition. The lookup key determines which partition's local file to query. This is different from serial lookup files which are shared across all partitions.