MSBI Interview Questions (Part 8)

Session on 15-10-13(FM)

· Second Max of Emp without using CTE (5th after 7th)
· Please write query for Retrieve Except colour Blue Records only

Product Id	Name	Colour
1	Soap	Black
2	Vehicle	Blue
3	XXXX	Red
4	ZZZZ	Orange
5	AAAA	Metal
6	BBBB	Blue

· What is Difference between Delete and Truncate
· Performance Tuning in SSIS
· Explain Flow draw of ForEachLoop Container with Example
· Difference between Function and SP
· Cluster and Non Cluster Indexes
· Write a Query for Below I/P and O/P
  I/P

Year	Month	Sales
2012	Jan	10000
2012	Feb	20000

O/P

Year	Jan	Feb
2012	10000	20000

· What is O/P

Select 1
Union all
Select 1

· How to Create Cube (Clearly Explain)

MSBI Interview Questions (Part 7)

Session on 13-10-13(TL)

1. What is Data Ware house and Advantages
2. How to Improve Performance by using Analysis Services
3. KPI and Example
4. What is use of SSAS
5. How to End users performance with Cube
6. What is use of ad hoc Reporting
7. Perspectives and uses
8. Significance of cube
9. Remove orphan records in ur database( It contains 2 or 3 Millions)
10. Table contains 100 records and View contains 200 records (both the structures are same). How to get         300 records by using SQL Command
11. How to create Data Ware house
12. Types of Dimensions & Measures
13. Cleary Explain Degenerate Dimension & Role Played Dimension
14. Cluster and Non Clustered Indexes
15. How to Explain Indexes Concept Briefly with Example
16. Sub Query’s and Types

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

SQL Server Interview Questions (Part 2)

Session on 12-10-13(FA)

· Execute Plan of Query (Sql Server)
· What is Difference between Merge and Merge Join
· Instead of Trigger (Example)
· Print Command Write in Function is Possible or Not
· How To Handle Bottle neck Problems in Sql Server
· Difference between Delete & Truncate
· Difference between Char & Varchar
· Difference between Stored Procedures & Functions
· U Pass Table Variable Parameter to Stored Procedure
· What is Clustered and Non Cluster Indexes? Explain Clearly
· What is B Tree and Explain Leaf Node
· What is Result of
Q-1
Begin Transaction T1
Insert Row1
Begin Transaction T2
Insert Row2
Rollback T2
Commit T1

Q-2
Begin Transaction T1
Insert Row1
Begin Transaction T2
Insert Row2
Commit T2
Rollback T1

· Write a Delete Statement of Duplicate Records(sno,name are Primary Keys)
  Sno,name,amt
  1,aaaa,20
  1,aaaa,30
  1,aaaa,20

MSBI Interview Questions (Part 5)

Session on 08-10-13(TL)

1. What are Types of Dimensions
2. Package Configurations used to in ur Project
3. Please Explain XML and Environment Variable Configurations
4. How u Achieve Parallelism in SSIS
5. One Flat file Contains some Codes how to eliminate the codes and finally stores in ur Database
6. What is use of Audit File in ur Packages
7. Difference between Union all & Merge Join & Merge
8. What is the Difference between OLTP and OLAP
9. What is Fact less Fact
10. What type of Reports u Worked on ur Project
11. What is Cascading Parameters
12. What are the Rendering Methods in SSRS
13. Disable One Option in Rendering Methods in SSRS


Session on 08-10-13(TR)

1. What type of Transformations u worked on it
2. What is significant of catch (Full & Partial)
3. What is Types of SCD’s
4. U Create SSIS Package. It have 10 files but i want only deploy 5 files
5. How to Pass Variables from Parent Package to Child Package (Clearly Explain with Example. In this Ex which variable is changed)
6. To create one Package with Data Source but the Data source is down that time Package run or not and What type of Errors are Occurred
7. What is Logging Information
8. How to Aggregate SSAS Cube with SSIS Package
9. U can Only Process Single Partition of the Cube
10. What is use of Having Clause in Sql
11. Can we call SP in side Function
12. What is the Difference between Derived Measure and Calculated Measures?
13. What are Functions used in MDX
14. In SSRS Detailed Report is Display in the Same Page.
15. Standard Terminology of Sub Reports in SSRS
16. What is Degenerated Dimension

SQL Server Interview Questions (Part 1)

Session on 08-10-13(TL)

· Data ware Development Life Cycle.
· What is the Stored Procedure(SP).
· What is the Precompiled Option in SP.
· One table and One View, The structure was same but not related with each other.Table Contains 100            Rows &View Contains 200 Rows. Now Please Write Query for Total Rows in those Two.
· One Table u finds orphan records in a database.(orphan means their parent record_ in another table has        been deleted) Employee table & Employee Parent table but some time deleted records in Employee              Parent table only. How to find which records are deleted in Parent Table.
· Difference between Merge and Merge Join
· One table u Delete Duplicate Records without used CTE
· Triggers and Explain Types.
· What is the Mechanism for Triggers and Explain Briefly(How to Run Triggers)
· Indexes and what is the difference between Rebuild Index and Re organize Index
· 3 Triggers in a Table (Table have 20 Columns) First Trigger writes in first 3 columns in a table. Second          Trigger writes in 4 to 9 columns in a table. Third Trigger writes in 10 after in a table. Can u Please Explain?    If write any Operation what is order of Triggers are Executed.
· What is Select into & Insert into
· One table have Primary key. Can i use Non Clustered Index on Primary key

MSBI Interview Questions (Part 4)

Session on 03-10-13

· Difference between Union & Union All Transformations?
· How to Run Packages Parallel in SSIS?
· How to Deploy the Cube?
· In DSV Tables or Named Query Calculations. Which one is Execute One?
· Perspectives and Explain what is use of Perspectives?
· How to Delete Duplicate Rows in a Table?
· Logging and Explain how many types are Available?
· Explain SDLC (Software Development Life Cycle)?
· Drawbacks in SSRS Reports?


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 Reports
· How Many Types of Subscriptions
· How can handle Multi valued Parameters
· Which Transformation is used Update Command in Data
· How to Maintain Package Optimization

MSBI Interview Questions (Part 3)

Session on 26-09-2013(T)

· Generally what type of issues u face getting data from various sources?
· What type of Package Configurations used?
· I have on ssis package one sequence container. In Dataflow task and execute sql task is there. That time        what type transactions in database (Rollback transactions).How to delete data from database
· Difference between Data path and Precedent Constraints
· What type of Property used do u need to Order Feature in SSIS?
· How to schedule the package and types?
· Logging in SSIS?
· Difference between Sequence Container and For each loop Container
· Difference between Stored Procedure and Functions
· Indexes and Types of Indexes & Drawback of Indexes

Table1 - Product id, Product name
Table2 – Product group
Table3 – Sales amounts of products

Now i want sum of sales of product group.


Session on 28-09-2013(W)

· Difference between Merge and Union All?
· Difference between Merge and Merge Join?
· Using Merge Join Transformation Before not using Sort Transformation?
· How can you terminate a dataflow path without a Destination?
· Performance Considerations given while dealing with SCD’s?
· Command Line Tools to execute & Manage SSIS Package?
· Define Normalization, Boyee&Codd Normal Form?
· Difference between OLEDB Destination and SQL Server Destination?

· How to get 08-01-2013 Balance of Account No – 1

Account No	Account Balance	Date
1	1000	01-01-2013
1	2000	02-01-2013
1	1500	03-01-2013
1	1700	05-01-2013
1	1400	12-01-2013
1	3400	15-01-2013

· How to get Error Data of Below Table

S.no	Name	Age
1	28	Aaaaaaaa
Bbbbbb	2Bbbbbb	23
3	Ccccccc	Vvvvvvvvv
Dddddd	4ddddd	45
5	eeeeeeeee	56
6	Fffffffffff	67wwwww

Final Table data and Error Information go to Client by Mail.

· Date Validations and Explain Clearly with Example?

· Customer Information Table : -

Account No	Account Name	Date
1	A	01-01-2013
2	B	02-01-2013
3	C	03-01-2013
4	D	05-01-2013
5	E	12-01-2013
6	F	15-01-2013

Account Balance Table: -

Account No	Balance
1	10000
2	4500
3	5400
4	22000
5	4400
6	3000

Update Balance above 5000 + 10% added and below 5000 - 10%
By using single Query in Sql Command.


Session on 30-09-2013(TC)

· U Gather Requirement from Client or BI Team. How take Requirement Gathering from manager?
· One Excel file contains 10 Columns and Another Excel file contains 15 Columns. How to get data from two Excel Files.
· What is SDLC? Which state u worked in ur Project
· How many dimensions and fact u worked on in ur Project & How to work with Maximum Size of                 Dimensions and Facts like 20 Facts and 15 Dimensions.
· How many ways to Deployment SSIS Package
· Variables and Explain Variable Scope
· Fuzzy Grouping and Fuzzy Look up , Unpivot
· How to Handle Error Handlings in SSIS
· How Variables in Data Warehouse Concept
· Explain DTS and SSIS, Difference also
· What is UDM
· What is use of SSAS Components
· How Cubes are implemented in SSAS
· What is Ragged Hierarchy?
· What are Different Ways of Creating Aggregations?
· What is Write Back Property in Partition?
· What are SSRS Components?
· What is Report Builder?
· Running SSRS Reporting in Windows XP create no of Users?
· What are Drawbacks in SSRS Reports?

Session on 08-10-13(TL)

· Data ware Development Life Cycle
· What is the Stored Procedure(SP)
· What is the Precompiled Option in SP
· One table and One View, The structure was same but not related with each other.Table Contains 100 Rows &View Contains 200 Rows. Now Please Write Query for Total Rows in those Two.
· One Table u finds orphan records in a database.(orphan means their parent record_ in another table has been deleted) Employee table & Employee Parent table but some time deleted records in Employee Parent table only. How to find which records are deleted in Parent Table
· Difference between Merge and Merge Join
· One table u Delete Duplicate Records without used CTE
· Triggers and Explain Types.
· What is the Mechanism for Triggers and Explain Briefly(How to Run Triggers)
· Indexes and what is the difference between Rebuild Index and Re organize Index
· 3 Triggers in a Table (Table have 20 Columns) First Trigger writes in first 3 columns in a table. Second Trigger writes in 4 to 9 columns in a table. Third Trigger writes in 10 after in a table. Can u Please Explain? If write any Operation what is order of Triggers are Executed.
· What is Select into & Insert into
· One table have Primary key. Can i use Non Clustered Index on Primary key