Explain lookup transformation
Lookup transformation helps you to finds outsource qualifier. It may be either active/passive lookup transformation.