MSBI Interview Questions & Answers Part 1

1. Why SSIS? What is the use of ETL?
2. What is difference between SSIS and SSAS?
3. Diference between union all and merge transformation?
4. What is difference between Multicast and Conditional Split?
5. What are the performance issues you have faced in SSIS?
6. What is a cross apply and how to use this?
7. What is CTE?Can we use more than one CTE in a single select query?
8. what is control flow and dataflow?
9. What is the difference between drilldown and drill through report?
10. How to implement type 2 SCD using SSIS and queries?

Notes : 

A drill through report allows you to go from summary to detail.

A drill down reports allows you to look to the data in different levels.

Slowly Changing Dimension in ssis support

Fixed Attribute

Select this type when the values in a column should not change.Changes are treated as errors.

Changing Attribute

Select this type when changed values should overwrite existing values.This is a Type 1 change.

Historical Attribute

Select this type when changes in column values are saved in new records.Previous values are saved in a records marked as outdated.This is a Type 2 change.