Question: what is the difference between normal lookup and sparse lookup?
Answer: Normal lookup: All the data from the database is read into memory, and then lookup is performed. Sparse lookup: For each incoming row from the primary link, the SQL is fired on database at run time. 2)Sparse lookups can be used if the input data is smaller than the reference data.