<Insert Picture Here>

datagapsThe data testing company

Referential Integrity Test

Objective

• As a QA Engineer, I want to ensure that the referential integrity requirements are met in the warehouse

Click Here

Select Foreign Key Compare Test Plan

Select Database Connection and an identifier for “Unspecified Rows (Optional)

If the connection does not have a data model defined, click on this button to create one with joins

Choose one or more entities or joins. The joins shown here are from the data model.

Click ‘View Model’ for editing join or adding joins.

Set Acceptable Variance

Clicking on Run will display results as shown below

To view query used, click on ‘View’