1. Explain your role in Project?
  2. Explain your Project in detail

SSIS :
  1. What all transformations did you used?
  2. What is the difference between Merge and Union All?
  3. What is the difference between COPY Column and Derived Column?
  4. What are the different Container available in SSIS?
  5. How you have used lookup transformation? When to USe Full cache and Partial cache?
  6. Explain types of configuration in SSIS
  7. What is Checkpoint? How to use?
  8. Does Checkpoint work for FOREACH Loop? If not, what is an alternative solution?
  9. Difference between Control Flow and Data Flow?
  10. What is Precedence Constraints?
  11. What all connections you have used in your project?
  12. How you have handled error in our project?
  13. How to deploy SSIS package? Explain different types of Deployment.
  14. What is logging? How to use it?
  15. What is Transaction in SSIS?
  16. What is Synchronous and Asynchronous Transformation?
  17. What is execution tree?
  18. How to improve performance of SSIS packages?
  19. What are the features of SSIS latest version?
  20. Have you used Excel connection? Have you faced any challenges?
  21. What is Unicode, NonUnicode Strings? Excel source is UniCode or NonUnicode ?
  22. How to debug error if it occurs in Production environment?
  23. What are buffers in SSIS?
  24. How parallel execution works?
  25. Exception Handling in SSIS?
  26. Have you worked with SCD? How it works, explain in detail?
  27. What is the Fixed Attribute? If its fixed why it is called in SCD?
  28. How to schedule package using scheduler?
  29. If there are 100 files to load. We are using DFD task to load. If 96 files got correctly and task failed at 97 file. How will you handle? Do we need to load all files again?
  30. If we have trigger on Table for delete event. ANd we have used delete query in SSIS task? How it will work?
  31. We have below container containing 3 Tasks.( Task A, Task B and Task C).
  • All Tasks are running parallely. If tasks C fails in Between, what will happen? All tasks will stop? Container got fail?
  • How to handle this scenario?
  • On which task we need to create an event in event handler?
  1. Consider the above container is complete package, can we run this package parallely on same server?
  2. We have some excel and text files at one location and we need to load all these files into the same destination table. How to load both types of files from location into destination table?
SQL:
  1. What will be the output for table for all joins
Table A Table B
1 1
1 1
1 1
0 0
0 0
NULL NULL
  1. Error handling in stored procedure
  2. SQL 2012 features
  3. Types of Index and their uses?
  4. What is covering index?
  5. What is the use of CTE?
  6. Performance tuning in SQL query?
  7. Write different query to get below result from given table
Table:
EmpId
EmpName
ManagerID
1
A
2
2
B
3
3
C
NULL

Result:

EmpName
ManagerName
A
B
B
C
C
NULL

  1. Write result of All joins for below 2 Tables

Id
Name
1
A
2
B
3
A
3
C
NULL
D

Id
Name
2
A
2
A
3
B
4
C
5
D

  1. Consider the above tables A & B. Check the id of Table A with Table B. If id matches then update Name of table B with table A value
  2. How to show error message in SQL Server?
  3. What is Trigger? How it works?
  4. What is Normalisation? Explain different types of Normalisation.
  5. If we have simple insert statement in Stored Procedure. Which method give faster results? Executing STored Procedure or Direct Insert Statement?
  6. What is MErge in SQl? How to use it?
  7. What is view? Can we create index on view?
  8. What is transaction?
  9. Difference between Stored Procedure and Function
  10. What is Primary Key and Foriegn Key?
  11. What is Unique Key? Can we handle NULL data in Unique Key?
  12. Can we delete records from view created on 2 tables?
  13. What is Execution Plan? When and How to use it?
  14. EmpSales:

id
name
add
sal
1
A
xyz
2000
2
B
pqr
3000

EmpAcc:

id
name
add
sal
1
A
xyz
2000
2
B
pqr
3000

What will the result of below query:
SELECT id, name, add, sal FROM EmpSales
UNION
SELECT id, name, sal, add FROM EmpAcc

  1. How to remove duplicate records from table?
  2. What is the difference between Temp Table and CTE?
  3. Can we pass table as a Parameter to Stored Procedure? If YEs, How to pass it?
  4. Can we call stored procedure inside another stored procedure?
  5. Table A:

id
name 
sal
1
A
200
2
B
300
3
C
400
Write query to get below output?

id
Name
sal
New column
1
A
200
200
2
B
300
500
3
C
400
900


id
Name
sal
New column
1
A
200
300
2
B
300
400
3
C
400
NULL

  1. How to execute stored procedure with output parameter?
  2. What is ROW_NUMBER(), RANK() and DENSE_RANK() function?
  3. Can we use DML statement on views?
  4. What is the use of Cross Join? Explain with example
  5. What is meant by Business Key and Surrogate Key? What is the difference between them?
  6. Can I delete record from view?
  7. What happen in background when we fire “select * from tablename” query?
SSRS:
  1. What types of reports you have created in your project?
  2. What is cascade parameter report?
  3. How to create drill down report?
  4. How to deploy report?
  5. What is report subscription?
  6. Can we use stored procedure in SSRS report?
  7. What is report server and report manager?