Infogain Interview Question

related to MSBI. SSIS, SQL SERVER, TSQL