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