Questions to be followed and ASK
DWH
1.Diff Star Schema and Snow Flake schema?
2.What is Fact less fact table?
3.what is Confirmed Dimension
  T-SQL 
1.How to insert values to the identity column in SQL Server?
2.Delete Duplicate Records from a table?
3.How To improve stored proc performance?
4.Types of joins?
5.Difference b/w CTE and temp tables?
6.what is outer apply and cross apply
7.index types and what is the cover index?
8.Difference between Stored Procedure and Function in SQL Server?

SSRS

1.How do u implement the Cascading parameter in SSRS?
2. How do u implement Multi value parameter in SSRS?
3.What is Drill through the report?
4.What is Subreport?
5.diff b/w Tablix and matrix report?
6.How to implement Report Security?
7. How to implement Report Subscription?
8.How to Show all records in single page in SSRS?
9.Show report header in all the pages in SSRS?

10.tell me critical report which you created in SSRS?