Next Meeting: Wed, Sep 17 2014
Winnipeg SQL UG - September 2014
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
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
How do I create an automated ETL test suite?
Terry Bunio Protegra
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.
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.