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
