1. Explain your roles and responsibilities in your project?
  2. Explain Scenario in your project?
  3. How the data load into the fact table in your project ?
  4. Which types of transformations you have used  to load data in fact table in your project?
  5. Which types of indexes you have used in fact table?
  6. What is the difference between Fact table and Dimension table ?
  7. Can we create a primary key on table having clustered index already?
  8. How to improve performance of existing procedures?
  9. Which types of transformations you have used in your project?
  10. Explain different types of join?
  11. For below tables what will be the output of below joins:
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN
CROSS JOIN
Table A Table B
1 1
1 1
1 1
0 1
NULL
  1. What will be the output of below query?
Table 1 Table2
1 1
1 1
1 1
0 1
4 NULL
5
6
SELECT Table1.ID FROM Table1
WHERE Table1.ID NOT IN (SELECT Table2.ID FROM Table2)

  1. What is the difference between Drill Through and SubReports?
  2. Have you used Subscriptions in your project? Explain it?