Need for SSIS and ETL / DWH Entities

Data Warehouse Design and SSIS

DW Components and SSIS Tools

SSIS Configuration and Catalog DB

Control Flow Tasks Architecture

Data Flow Tasks and ETL Architecture

Data Pipelines and Data Buffers

SSIS Data Types and Data Conversions

SSIS Local and Global Variables

Dynamic Precedence Constraints

Dynamic Connection Managers in DFT

Data Flow Transformations and Usage

Handling ETL Enumerations in SSIS

ETL with Loops & Indexed Connections

Conditional Precedence Expressions

SSIS Parameters Usage and Variables

Control Flow Breakpoints – Usage

Data Flow Data Viewers and Audits

SSIS Expressions & Debugging Options

Debugging SSIS Packages & Limitations

Debugging Procedures in Realtime

Row and Column Transformations

Combining and Splitting Data

Performing SQL Database Operations

MERGE Vs UNION ALL Transformations

Lookup, Fuzzy Lookup and Grouping

SORT Vs AGGREGATE Transformations

OLE-DB Command Usage & Parameters

Derived Columns & Data Conversions

SSIS Parameter Mappings & Options

Tabular Data Stream & Commit Size

Table Locks & Batch Calculations

SSIS SCRIPT Task (.NET) and Coding

Scripts for Control Flow Limitations

Scripts for Data Flow Limitations

ADO Connections and DataAdapters

Custom Code (.NET) Handling in SSIS

Script Tasks & Notify Operators

SSIS Expressions and Iterations

Data Analytics and Column Profiling

Data Sampling and Data Delta

Type I and Type II SCD Examples

Dimension Table Design, Surrogate Keys

SCD – Business Keys and Attributes

SCD – Historical Attributes and Status

Event Notifications and Emails

ETL – Partial and Full Cache Options

Fact Table Loads and ETL Load IDs

PIVOT, UNPIVOT and WebService T/Fs

TDS Sizing and Memory Options

CHECKSUM Transformation in DW

CACHE Transformation & Usage

Partial and Full Cache Options

SSIS Transactions & Isolation Levels

Checksum for Type 1 and Type 2

SSIS Checkpoints and Limitations

CDC Sources and Controls in SSIS

CDC Tables and Change Tracking

Dynamic CDC Connections & Logging

Using CDC for Dimension Loads (ETL)

Configuring Master Packages, Parameters

Configuring Child Packages, Parameters

Parameter Bindings, Execute Process

Fact Loads with SSIS CDC Controls

OLE DB Transformation and Parameters

ADO.Net Connection Limitations in SSIS

Solutions to Data Delta Options

SSIS Package Events and Audits

Package Level Event Handling Options

SSIS Event Bubbling Escalations

SSIS Logging & Project Connections

Windows Event Logs and SSIS Jobs

SQL Server Logging and Audit Tables

Global Connections and Project Audits

Logging Fuzzy Data Loads and ETL

Need For XML Connections & ADO

XML Connections & BLOB Data

Using SSIS Data Profile Viewer Task

Project Builds & Bit Level Options

Creating ISPAC Files : SSIS 2014, 2012

Securing SSIS Manifest Files (PROD)

64 bit and 32 bit Configurations

Validation & Verification Techniques

Configuration Options and Connections

Control Loops and Indexed Connections

Migrating SSIS ISPAC Files & Options

SSIS Package Backups and Passwords

Project Level Passwords and Encryption

SSIS Deployment and SSIS Catalog DB

SSIS Catalog Project Files and Options

Security – Logins, Users, SSIS Admin

SSIS Catalog Folders in SSISDB

Post Deployments & Connections

Package Configurations, Parameters

SSIS Package Validations, Reports

SSIS Package Executions, Reports

Checksum Management and Encryptions

SSIS Package Scripts with T-SQL

Tuning Deployment and Configurations

SSIS Package Performance Reports

SSIS Package Security Options

Encrypting SSIS Catalog Packages

SSIS Package Store and SSISDB

Security Audits Reports and Limitations

SSIS Folder Level Security Options

Project Level Security and SSIS Roles

Container and Package Logging

SSIS Project Migration Utilities

Importing ISPAC and Manifest Files

SSIS Project Import Wizard – Usage

Upgrading Packages & Configurations

Command-Line Deployments & Options

Package Backup Procedures & Options

Scheduling Packages (Jobs), Operators

Upgrading SSIS 2012 to SSIS 2014

MSDB and SSIS Catalog DB Files

Comparing SSIS 2012 and 2014

SSIS ETL and DW – Comparisons

Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Mindmajix verifies their technical background and expertise.

We record each LIVE class session you undergo through and we will share the recordings of each session/class.

Trainer will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.

If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.

The Training itself is Real-time Project Oriented.

Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

There are some Group discounts available if the participants are more than 2.

As we are one of the leading providers of Online training, We have customers from USA, UK, Canada, Australia, UAE, Qatar, NZ, Singapore, Malaysia, India and other parts of the world. We are located in USA. Offering Online Training in Cities like

Minneapolis, Melbourne, Jacksonville, Davidson, Murfreesboro, Auckland, Carlsbad,  San Marcos, Tacoma, Bellevue, Garland, Raleigh-Cary, Fort Lauderdale, Miami, Toronto, Wellington, Gilbert, Tempe, Alexandria, Chandler, Scottsdale, Peoria, Honolulu, Raleigh, Nashville, Plano, Montreal, Calgary, Edmonton, Saint John, Vancouver, Richmond, Mississauga, Saskatoon, Kingston, Kelowna, Hyderabad, Bangalore, Pune, Mumbai, Delhi, Dubai, Doha, Brisbane, Perth etc…