Companywise Interview Questions
Unknown Company Interview Questions - 5
SQL:
- Describe the Join operations : What is the self join? Please explain in detail using one example.
- What is the difference between varchar & char data types?
- 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?
- What types of indexes supported in SQL Server 2016?
- What are the new features in SQL Server 2016?
- Suppose we join around 10+ tables and query performance is very poor, how to check & optimize the query performance?
- Are you worked in Link Servers? If yes, please explain the same.
- How to monitor SQL Jobs using the SQL Queries or SQL Agent?
- Are you worked in complex stored procedure?
- What is the difference between stored procedure & function? Why we are using stored procedure? What are the benefits for the Stored Procedure?
SSIS :
- Describe the SSIS. Explain the flow how to create normal SSIS ETL Package?
- What are the data Transformations you used in ETL Packages? Explain in detail.
- Explain how to load Incremental data using SSIS tool?
- Difference between Merge Transformation & Lookup Transformation?
- Explain how to deploy the ETL packages using SSIS 2016?
- What are the new features in SSIS 2016?
- 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?
- How we check ETL errors using the SSIS catalog?
- In case of ETL Package failed, Should we trigger email with the ERROR description? If yes, Please explain in details.
- Explain Master & Child ETL Packages logic for loading the data.
- 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.
Post a Comment
0 Comments