what is the purpose of the lookup transformation, computer science homework help

Minimum of 450 words with in-text citations and references for each question and make sure no plagiarism.1. What is the purpose of the lookup transformation ?2. What is the purpose of the aggregate transformation ?