Interview 1
- Explain about the project
- Tell me abou the challenges faced in your project
- Different configuration options in ssis
- Difference between union and union all
- can we use cte inside while loop
- diiference between row_num, rank and dense_rank
- what are confirmed dimensions and factless fact table
- Tell me about SCD
- In SSRS report, I have a subreport. I do not want the data set for the subreport to be executed. How do you do it.
- I have an excel with 10 sheets. I want data of all 10 sheets to be loaded to a single table
