Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Introduction

MettleCI Unit Tests are execute by running your DataStage job as you normally would but with the addition of a parameter value which invokes the MettleCI Unit Test Harness.  When you do this, the following process occurs:

Table of Contents
minLevel3

Multimedia
nameunit-test-run-720.mov
width640
height360


Step-by-step Guide

1. Run DataStage Job in Unit Testing Mode

Run your DataStage Job in Unit Testing Mode by Enabled selecting 'Testing' as the input value to the pUnitTesting optionjob parameter.

Image Removed

YouImage Added


Once your job is running you'll see the input link counts on the DataStage job canvas represent the number of rows in each of your Unit Testing input data sets.

Image RemovedImage Added

You'll also see a warning in the DataStage job log telling you that unit testing is enabled. 

8

2. Check Unit Tests List

Navigate back to Unit Tests List from the sidebar. You can now see Unit Test for ER_EMPLOYEE created.

Due to the fact that we did not specify an output for comparison. The result is in RED colour. 

Image Modified

9. Output mismatch report

By clicking on the RED view result button above, it will bring you a summary report of the Unit Test

Image Removed

10. Baseline Output Data

If we go back to Unit Test Setting for TR_EMPLOYEE, we can now see the output of the first run is now set at the baseline of the output

Image Removed

11. Rerun Unit Test

If we rerun the Unit Test again, the test summary report will produce a report of perfect matched output.


3. Unit Test results  report

You can view your Unit Test results by clicking the red View button alongside your test name. 


A failed Unit Test will report differences for each output link:

Image Added


A Unit Test will only report success when all output links have zero differences from their expected results:

Image Modified