Genpact interview question

Few SQL questions, questions ADF, SSIS