In Ab Initio, lookup() is used for serial lookup files (single file), while lookup_local() is specifically designed for multifile lookup systems. Using the correct function for each file type is important for optimal performance and proper access patterns.