A lookup file contains a static reference dataset that is keyed, allowing you to join with transactional data during processing to enrich or validate records. Common examples include state code mappings, currency conversion tables, or product catalogs that don't change frequently. Unlike intermediate files, lookup files are pre-loaded before processing begins.