Explain the use lookup tables and Aggregate tables? | ETL Testing Interview Questions

An aggregate table contains summarized view of data.
Lookup tables, using the primary key of the target, allow updating of records based on the lookup condition.