Analog Devices interview question

Lookup in SSIS Data warehouse design SQL basic queries