Enablement of partial or work item level execution in DTV tool

[abhyarthana]

Problem Statement

If you are already using DTV tool for business data validation, you may already know that DTV generates work items as per the split parameters provided in the test specifications.

Customers may sometimes get to a scenario where they wish to.

• Execute individual or set of work items of their choice
• Execute failed/ cancelled work items only

To address such requirements DTV tool introduces partial execution or work item level execution in the new release DTV 1.5. With this concept Execution of extraction, evaluation and simulation are possible not only at the test specification, but also at the individual split (Work items).

Work Items

With DTV 1.5 release onwards, the tool is introduced with new concept called work item level execution. For each Extraction/Simulation, the tool generates work items explicitly first and then the work item level execution happens for respective work items. In this way DTV facilitates smaller data extraction as well as if extraction for one or more work item fails/cancels, you can run the failed/cancelled work items explicitly which makes the overall DTV execution faster.

You can find the Generate Workitems buttons in both Simulation as well as Extraction screens as highlighted below.

Once the work items are generated by using the above button, the execution status changes to

You can see the generated work items in the Result tab.

Project Global Data and Work Items

In DTV project global data is used to split the business data into smaller chunks and the project global data is also applicable to all the reports. But it is worth to mention that the definition of project global data is directly related to number of work items that will be generated during the Extraction / Simulation phase.

In the below example of project global data, only one work item will be created.

However, it is always recommended to further split the project global data to generate multiple work items for smaller and faster simulation/extraction. Below is a simple example of further finetuning of the project global data.

Define Project Global data wisely to split the data into smaller chunks (work items)

You can define the project global data wisely by splitting, which in turn will create multiple work items. E.g. For the below project global data 5 work items will be generated.

Check the work items created in Result tab.

Once work items are generated you can execute the work items with different options as per your requirement

• Execute all the work items together (by default)
• You can select multiple work items as per your requirement and execute
• You can also execute the failed or cancelled work items only

Select multiple work items and run

If you have generated multiple work items and you would like to execute only few, you have the possibility to select the desired work items and execute simulation or extraction.

Select failed work items and run

If there are failed or cancelled work items, you can simply select the failed work item and execute the simulation or extraction.

DTV Useful links

Business data validation using DTV tool

Best practices to follow during DTV implementation

3117879 - Data Transition Validation DTV Tool - Central Note

3569864 - DTV Tool 1.6 Delivery