MSBI Interview Questions (Part 6)

Session on 12-10-13(FA)

· What is Connection Pooling
· By Using SSIS Aggregation How Many Outputs are there
· Unit Testing in SSIS
· What is Dimension Table & Fact Table
· Different Types of Measures and Explain with Examples
· Explain Clearly Architecture of UDM
· Where is used Surrogate key
· Explain about SCD’s
· Different Types of Schemas and Which one is More Normalized
· Different Types of Containers
· Different Types of Sources in SSIS
· In Ur Project used OLDB or Sql Destinations
· What is Reason u used OLDB Destination
· Synchronous & Asynchronous Transformations (Explain with Example)
· Blocking & Non Blocking & Partial Blocking also(with Examples)
· Difference between Merge & Merge Join & Union all
· With Out Sort Transformation using Merge Join Operation
· Configurations and Explain Direct & In Direct Configurations
· Explain about Sequence Container with Example
· Drill Through & Drill Down Report s
· How to Display below Graph

· How Many Types of Subscriptions
· How can handle Multi valued Parameters
· Which Transformation is used Update Command in Data
· How to Maintain Package Optimization