Share:

A Data Profile Test Case can be used for comparing data from a single Source and Target query.

You can use this test case for comparing Count, Count Distinct, Max, and Min aggregate values on results returned by Source and Target queries. A Visual Query Builder is available to help you select the columns in the Data Model and generate the query automatically for comparison. 

This test case is used when you want to verify the data moved from Source to Target database.   


Create a Data Profile Test Case

There are several methods to launch the Data Profile Test Case in the ETL Validator.

Depending on your convenience, select any one of the following methods:

  • Method 1
    Mouse hover over the plus icon and select Data Profile Test Case.
  • Method 2
  1. On the side menu, click TEST CASES.
  2. Click Tests +.
  3. Under Data Comparison Tests, select Data Profile Test Case.
  • Method 3
  1. On the side menu, click HOME.
  2. Under Common Tasks, Click Create Tests.
  3. Under Data Comparison Tests, select Data Profile Test Case.

Open/Edit a Data Profile Test Case

To open/edit a Data Profile Test Case,

  1. On the side menu, click TEST CASES.
  2. In the Test Cases tree, select the folder containing the Data Profile Test Case.
  3. Click on the name of the Data Profile Test Case.
Information You can also open a test case from the TEST RUNS view

Data Profile Test Case Details

When you want to create or edit a Data Profile Test Case, complete the information in the following pages.

Start

In the Start page, you will complete basic details like name, database and folder.

This page contains the following:

TEST CASE NAME

Enter a name for the Data Compare Test Case.

TEST SUITE

Select the test suite where you want to create the test case.

TEST FOLDER

Select the folder where you want to create the test case.

PRIORITY

Select the priority to let your team know about the significance of the Test Case. Available priorities are Lowest, Low, Medium, High, and Highest.

Mark as Private

If selected, the user who selected this option and admin users will only be able to work on this test case. If an admin user select this option while creating the test case, normal users can see the test case, but can not open and work on the test case. 

Description

Enter a description for the Data Profile Test Case.

Label

Create a label for easy identification of test plan. To create a label, click the Click to add label link, enter a label name, and press Enter.

TARGET DB CONNECTION

Select a connection for the target database.

SOURCE DB CONNECTION

Select a connection for the source database.

WORK SCHEMA

Select a workschema where temporary tables with test data will be stored.

Queries

In this page, you create and execute a query. To create a query, simply type in the query for Target and Source or use Query Builder. 

This page contains the following:

Query Builder

Allows you to create a query using the data model defined for the database. If there is no data model, you can create one.

Execute Query

Allows you to execute the query for source/target and see results. When you click this button, the query is executed and the first 100 records are shown.

Execute Count Query

Allows you to view the actual count of result rows in source or target query.

Add Parameters

Allows you to add parameters to the source or target query.

Set Timeout

Allows you to set timeout in minutes for the ETL Server to wait before the query produces results.

Mapping

In this page, you will map the columns in target with columns in source.

This page contains the following:

Aggregate Functions

Select which aggregate functions to include in the test case run. By default, all of the functions are selected. You can select or leave any of the following aggregate functions. 

  • Count
  • Missing Values (nulls)
  • Count Distinct
  • Average (for numeric data types only)
  • Sum (for numeric data types only)
  • Max
  • Min
  • Max Length (for string data types only)
  • Min Length (for string data types only)

Allowed Variation (%)

Enter the percentage of variation to allow ETL Validator Server to pass the test case.

Remap Columns by Name

Selecting this option will display the mappings by column name.

Remap Columns by Order

Selecting this option will display the mappings by column order.

Run

In the final Run page, you will run the test plan. Before running the test case, read through the settings below once and understand their purpose.

The Run page contains the following:

Run

Allows you to run the test case.

Remove

Allows you to remove the selected test plan run.

Remove All

Allows you to remove the complete test plan run history.

Refresh

Allows you to refresh the Run page.

PreviousNext

© Datagaps. All rights reserved.
Send feedback on this topic to Datagaps Support