Automated ETL Testing Richard Thrust

ISBN:

Published: August 10th 2014

Kindle Edition

53 pages


Description

Automated ETL Testing  by  Richard Thrust

Automated ETL Testing by Richard Thrust
August 10th 2014 | Kindle Edition | PDF, EPUB, FB2, DjVu, audiobook, mp3, ZIP | 53 pages | ISBN: | 9.22 Mb

In this tutorial we well explain a unique and NEW approach to ETL Testing. It is a simple and easy to follow method that will allow you to increase your productivity by automating ETL testing. This method can be used to test Data Warehouse mappingsMoreIn this tutorial we well explain a unique and NEW approach to ETL Testing. It is a simple and easy to follow method that will allow you to increase your productivity by automating ETL testing.

This method can be used to test Data Warehouse mappings or with Data migration projects.In the first few chapters of this tutorial we will build an ETL environment, this will include: An Oracle Express Database, Java and SQL Developer.We will then explain all of the required Oracle DBA (Database Administrator) knowledge needed to set up a Source and Target schema. When the schemas have been created we will give you the scripts to create simple Source and Target tables.Next we will look at how to create a simple mapping from source to target using SQL with SQL developer.

We will only use SQL mappings as the focus of this tutorial is on how to automate the mapping testing.When we have an environment and mapping to test we move on to the core of the course, we explaining the approach we will use for testing mappings at table level and field level. We will also give you an Excel template test plan for storing your SQL test queries.The Excel template is a key part of this testing method, and we will see how to convert the Excel file into a format that will allow the SQL statements to be executed automatically. We will give you a FREE command line driven program, and the source code, which will produce an easy to follow report that indicates which steps passed or failed.It is a rare thing to see software pass all testing first time, so learn how to remove the need for tedious manual SQL testing by learning this exciting new ETL automation testing technique today!Table of contentsIntroductionBefore we startChapter 1 – Installing Oracle Express1.1 Download and install Oracle XE1.2 RecapChapter 2 – Installing Java and SQL Developer2.1 Download and install SQL Developer2.2 Set up SQL Developer Connections2.3 RecapChapter 3 – Oracle DBA Tasks3.1 Create accounts3.2 Add SQL Developer connections3.3 Create the SOURCE table3.4 Create the TARGET table3.4 Run a mapping to populate the target table3.5 RecapChapter 4 – SQL Testing Approach4.1 Target Table Design Tips4.1.1 Comparing data sets.4.2 Table Level Tests4.2.1 Completeness Check4.2.2 Business source key mapped.4.3 Field Level Mapping Tests4.4 RecapChapter 5 – A Source to Target Mapping5.1 Mapping Excel Spec5.2 RecapChapter 6 – Excel Test Plans6.1 Test plan components6.1.1 Test Step Name6.1.2 Field Name6.1.3 Description6.1.4 Expected Result6.1.5 SQL Statements6.2 RecapChapter 7 – Converting Excel Test Plans to XML7.1 The Excel Developer tab7.2 Adding an XML Mapping to an Excel Spreadsheet7.3 RecapChapter 8 – Auto ETL Installation8.1 XML Input files8.2 Outline of the Automated ETL module8.3 Data Structures8.3.1 run_log_header8.3.2 run_log_detail8.4 Installing the code8.5 RecapChapter 9 – Automating an ETL test9.1 SQLPLUS script commands9.2 DOS batch commands9.3 Specimen Test Report9.4 RecapChapter 10 – In conclusionAppendix – Listing of the Automated ETL codeBonus Material related to this eBookMore titles from Richard Thrust



Enter the sum





Related Archive Books



Related Books


Comments

Comments for "Automated ETL Testing":


optykpodzegarem.pl

©2010-2015 | DMCA | Contact us