Pergunta de entrevista da empresa Accenture

About project? What is Package Configuration? What is logging and non logging transformations? What is Ssis logging? What is container- sequence, for loop,& foreach loop? What is delay validation? What is lookup transformation and how to implement? What is breakpoint and check point? In which condition you will use breakpoint, checkpoint , delay validation and ssis logging and how to implement them all? What is multicast , data conversion and derived columns transformations? What is merge and Union All transformation and how to implement? What is variable? what is the work of row count transformation? How to implement transactions in ssis? Where u use and how to implement send mail task? What is Parent and child package? Scenario -> if u have text file , csv file , and excel file, u have to load it in Sql tables then which transformations do you use? How to Deploy and execute ssis package ? How to improve performance of package? Can we use Temp table in ssis if yes then how to implement it? If u have multiple sources with high volumn Data and u have to load data in destination , which task and transformations do you use in this case? Sql- 3rd highest salary, deplicate records, nth salary, triggers, functions , stored procedure, view, list down employees who join in last 6 month, date before 3months, date after 10 months, cross and self join, nested view, composite key, find the 2nd highest salary using sub query, indexes - clstred and non clstrd, normalization.