Tuesday 17 December 2013

MSBI Interview Questions (Part 10)

Session on 27-11-13(F_SYM)

1) What type of destiantions u use mostly
2) Difference between ole db destination & sql server destiantion
3) What if full cache,partial and no cahce
4) When do u give ignore failure,failure component
5) what is the input query u give in lookup
6) how would you map target tables in the target table
7) what is activex control flow task
8) what is the main purpose of lookup
9) what type of joins exist in it
10) what is the main diff between execute sql task and oledb command
11) what is the use of script component
12) Briefly explain when sources,destiantions and transformations exist
13) How would you map target table column with input units

Wednesday 27 November 2013

SQL Server Interview Questions (Part 4)

Session on 27-11-13(F_ACC)

· What is ur Project?
· Explain Roles & Responsibilities in ur Project
· What type of Transformations are used and Explain Briefly
· Explain about Performance tuning
· Error and Event Handling
· What type of Sql sever Objects are used in ur Project
· Joins
· Stored Procedures
· Functions and Types
· Views
· Indexes

Monday 25 November 2013

MSBI Interview Questions (Part 9)

Session on 26-11-13(F_BOA)

· How to u Find Data is there or not in Source
· What are the Containers are used in ur project and why
· Explains Precedence Constraints
· Difference between DTS & SSIS Package
· How to Handle Errors in SSIS
· How to Store Error Logs in SSIS
· What are the Configurations are used in ur Project
· Variables and Explain when u used Variables in ur Project
· In ur Project u used Sequence Container
· I want to Migrate data from Flat File to Sql Server , How the Performance can be improved
· Briefly Explains How many Stages in ur Project
· Script Task and Explain how many ways to ur Script Task in ur Project
· What type of Script used in ur project and Why
· What is Paradox Server and Explains

SQL Server Interview Questions (Part 3)

Session on 26-11-13(F_BOA)

· Difference between Having & Where Clause and both are using in same Select Command
· Difference between Join & Union
· How to Handle Errors in SP and How to Store Errors in Another Table
· How to Get Next Auto generated Value in Sql
· Sub Queries and Explain when u used SubQueries in ur Project
· How to find 2nd Largest Salary of Employee in a Table
· How to find 3rd Largest Salary of Employee in a Table
· In above Two Question without SubQueries u implemented or Not
· Explain Simple use of Substring , Lowercase and Uppercase

· Table1 contains Student Details like Student Number and Name, Table2 contains Student Marks and Grades. U find who had fallen between Minimum and Maximum Respective Grades

Thursday 17 October 2013

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)

Wednesday 16 October 2013

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

Saturday 12 October 2013

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

Friday 11 October 2013

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


Thursday 10 October 2013

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


Tuesday 8 October 2013

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





Thursday 3 October 2013

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









Wednesday 25 September 2013

MSBI Interview Questions- Part(2)

Session on 21-09-2013(F)

1. What Type of Connection Managers is used in ur project?
2. Transformations used in ur Project
3. What is use Merge Join
4. Sort Transformation is compulsory or not
5. How to eliminate duplicates
6. Audit information is useful or not
7. Event Handlers and used in ur project
8. Execute Sql Task, How to use in Real Time
9. Variables, Check Points in ur Project
10. How to check the data passing from source to destination correctly
11. Data viewers and Types
12. What is ur of User variables
13. Script Component and used in Project
14. Package Deployment
15. How do u do Package Configuration
16. How to u encryption data from one place to another place
17. What is CTE
18. What is Difference between Local and Global Temp Tables
19. How can u handle duplicate data using Temp tables or Another
20. How do u use Indexes and Types of Indexes
21. How long work with Mdx and SSAS
22. Aggregation and Partitions
23. Hierarchs and Types
24. Star and Snowflake Schemes
25. Report Builder and SSRS
26. Linked Reports and SubReports
27. Types of Reports
28. Types of Parameters
29. How to deleting options in report display at browser(only pdf)
30. Snapshots


Session on 24-09-2013(F)

1. Why is need of Data warehouse?
2. Package Optimization Methods
3. What type of source files are used in Project
4. How to Pull data in Data warehouse
5. How to Deploy the Report
6. What is Incremental Load
7. U create a variable in DataflowTask and used it Entire Package or not
8. U changes the scope of variable from Dataflowtask ->Package.

Thursday 5 September 2013

MSBI Interview Questions (Part-1)

Session on 06-07-2013(F)

1. Translators?
2. Write back Property?
3. Look up and Example clearly?

Session on 13-07-2013(F)
1. How many languages are used to retrieve data from cube?
2. Degeneration dimensions?
3. write back property
4. Named Calculations and example in real time
5. member,tuple,set definition explain and example
6. Named set
7. Aggregations
8. Creating cube , what challenges u faced
9. How to improve cube performance
10. Before cube creation process methods
11. Datawarehouse
12. Star & Showflake and difference between them
13. MOLAP , ROLAP, HOLAP
14. difference between parellelperiod and periods_to_date
15. YTD,MTD,QTD
16. what is current member
17. what is descendants
18. Drill Through Reports
19. Click Through Reports
20. Drill down Reports
21. sub report
22. one main report and two sub reports exports two in separate excels
23. ssis how to handle errors
24. what are transformations
25. character map transformations
26. blocking and non blocking
27. synchronous and asynchronous
28. hash index
29. Architectures of ssis,ssas,ssrs
30. Top 5 in MDX
31. snap shots

Session on 25-07-2013(F)
1. Types of constraints
2. Triggers
3. Constraints
4. How to initiate the triggers
5. 2nd highest salary of employees
6. ssis _ merge ,In merge any condition is used or not and explain brief example
7. Slowly changes dimension explain
8. Bulk insert task and give example
9. 100 to 1000 records are in database , u retrieve data from 100 to 200 records by using ssis transformations
10. design of cube
11. shared database ---> local database ---> destination tables. How to performs ssis transformations on it.
12. dimensions and fact
13. Check Points
14. How to place Check Points in package level or Task level and briefly explain
15. How about Loggings and types of Loggings