SQL:

  1. Describe the Join operations : What is the self join? Please explain in detail using one example.
  2. What types of joins
  3. What is the difference between varchar & char data types?
  4. We had created the view using CTE, view performance is very poor. It will take around 15+ minutes to fetch the data. How to enhance the view performance?
  5. What types of indexes supported in SQL Server 2016?
  6. What are the new features in SQL Server 2016?
  7. Suppose we join around 10+ tables and query performance is very poor, how to check & optimize the query performance?
  8. Are you worked in Link Servers? If yes, please explain the same.
  9. How to monitor SQL Jobs using the SQL Queries or SQL Agent?
  10. Are you worked in complex stored procedure?
  11. What is the difference between stored procedure & function? Why we are using stored procedure? What are the benefits for the Stored Procedure?
SSIS:
1) Describe the SSIS. Explain the flow how to create normal SSIS ETL Package?
2) What are the data Transformations you used in ETL Packages? Explain in detail.
3) Explain how to load Incremental data using SSIS tool?
4) Difference between Merge Transformation & Lookup Transformation?
5) Explain how to deploy the ETL packages using SSIS 2016?
6) What are the new features in SSIS 2016?
7) We deployed SSIS ETL package in SSIS Catalog & we created the job to execute the Package, suppose the Job is failed due to SSIS Package error, how you can check the error & resolve the same?
8) How we check ETL errors using the SSIS catalog?
9) In case of ETL Package failed, Should we trigger email with the ERROR description? If yes, Please explain in details.
10) Explain Master & Child ETL Packages logic for loading the data.

11) Suppose, In one SSIS package we are loading the data in 4 different tables. Suppose, 3 tables data is loaded successfully & 1 table data load is failed, If I again execute the package, we don't need to load again 3 tables data because the data is successfully loaded. We want to load the data which is failed during the execution. How we will achieve that? Please explain in details.