MindQ are pioners in offering real time industrail experts hands MSBI(SSIS, SSAS, SSRS) training.
along with Real Time Project senarios. All the sessions are completely PRACTICAL.

Aggregate Transformation, Sort Transformation, Percentage Sampling Transformation,
Row Sampling Transformation, Pivot Transformation, Unpivot Transformation
Other Transformation

Export Column, Import Column, Audit, Row Count,
Slowly Changing Dimension
Data Flow Task
Split and Join Transformation
Understanding of Extraction, Transformation, Loading
Conditional Split, Multicast, Merge, Merge Join, Union All, Lookup
Data Flow Sources
Data Quality Transformation

ADO NET Source, Excel Source
Flat File Source,
OLE DB Source,
XML Source
Fuzzy Lookup, Fuzzy Grouping

Data Mining Transformation

Data Mining Query, Term Extraction, Term Lookup

Synchronous and Asynchronous Transformation
SSIS Expression
Data Sources
Module 1: Debugging and Managing Package Execution
Debugging Control Flow
Debugging Data Flow
Debugging Script Task
Packaging Configuring
XML File Configuring
Multiple Configuring File,
Package Logging
Module 2: Detecting and Handling Processing Errors
Error Handling
Basic Error Detection and Handling
Understanding of Event Handler
Maintaining Data Consistency with Transactions
Checkpoint, Checkpoint Restarts and Transaction
Module 3: Securing and Deploying SSIS Packages
Creating Deployment Utility,
Securing Package
Role – Based Security,
Deployment Option
Monitoring Package Execution and Event Logs
Optimizing SSIS Packages

* Resume preparation and Interview assistance will be provided.

For any further details please contact +91-9502991277 or
visit www.mindqonline.com
Please mail your queries to online@mindqsystems.com

Author: Mohammad

Related Posts: