Winnipeg SQL Server User Group

Event Detail

Meeting Date: Wed, Sep 17 2014

Winnipeg SQL UG - September 2014

Language: English
Event Type: In-Person
Online Meeting URL: None

******* Please note interim venue at St. Boniface Library ******** Pizza and drinks provided - Please do not forget to register so I have an accurate count for pizza


Event Time : Wed, Sep 17 2014 17:30 - 20:00 Central Daylight Time


St. Boniface Library - Salle Marie Lynn Bernard
131 Provencher Blvd
Winnipeg, Manitoba
Direction: Northeast corner of Provencher & Tache several parking spaces available across Tache and to the north plenty of free parking on streets around the building

Featured Presentation

How do I create an automated ETL test suite?

Speaker: Terry Bunio Protegra

Summary: There are many automated test frameworks available for different types of applications, but Extract, Transform, and Load (ETL) data movement applications seem to lack an efficient and easy to use automated test framework. We will review how to create automated tests with a data driven approach by showing how the tests self-generate based upon the data in the Information-Model schema in SQL Server and 4 slender custom tables that define the field data mapping between the source and target. The last half of the session will be a demonstration of the tests to illustrate how they execute. To do this we will quickly review the functionality of the tSQLt test framework and the stored procedure code we created that generates the tests. We will review the considerable functionality in tSQLt that makes ETL testing and database testing easy and efficient. We will execute hundreds of tests in the short time during the presentation.

About Terry: Terry started his career working with Adabas as a DBA., Over the next 20 years, Terry has worked with Oracle, Informix, Sybase, and Microsoft SQL Server as both a Data Modeler and DBA. Terry is a huge proponent of normalization and dimensional modeling. Terry has implemented Operational Data Stores, Data Warehouses, and ETL solutions for Investors Group, LPL Financial, Manitoba Blue Cross, and others. Terry has recently worked on integrating Agile practices into Database projects.


Past Events

Meeting Archive





Back to Top