SSIS:
  1. What is meant by synchronous and asynchronous transformation?
  2. what is SSIS configuration?
  3. Can we use temporary table in SSIS?
  4. Write down the data flow to import data from Excel to temporary table
  5. What is meant by Retain same connection?
  6. What is meant by Delay Validation?
  7. Explain CDC?
  8. Explain SCD?
  9. What is the need of SCD?
SSRS:
  1. How many reports and what kind of reports you have developed?
  2. How to deploy reports?
  3. What are the different types of subscriptions?
  4. How to configure email at report server?
  5. How to provide security to reports?
SQL:
  1. Temporary table and table variable gets created?
  2. Types of temporary table?
  3. Which is faster temporary table or table variable?
  4. How we can decide whether to use temporary table or derived table?
  5. Difference betweenSQL Server 2008, 2012 , 2014 and 2016?
  6. Merge statement
  7. Difference between Procedure and Functions?
  8. Difference between Multi Statement and Inline table valued functions?
  9. Write Query to find below O/p from given Table
Given Table:
Col1
Col2
Col3
NULL
abc
NULL
NULL
NULL
NULL
abc
NULL
NULL
NULL
NULL
NULL
NULL
NULL
abc
O/p:
Col1 Col2 Col3
abc abc abc
  1. Id
1
2
3
-1
-2
-3
O/p: Col1 Col2
6 -6
  1. Country
Ireland
China
Pakistan
Australia
India
O/p: India 1st then Other Countries
  1. O/p for all types of Joins
A B
1 1
1 C
1 -
2 NULL
C
NULL
3
NULL

  1. What is meant by transactions?
  2.  types of transactions?
  3.  magic tables
  4.  views and schemabinding