Table of Contents

Search

  1. Preface
  2. Introduction to Data Validation Option
  3. Repositories
  4. XML Data Source
  5. Tests for XML Data Sources
  6. Connections
  7. Expressions
  8. Table Pairs
  9. Tests for Table Pairs
  10. Single-Table Constraints
  11. Tests for Single-Table Constraints
  12. Examples of Tests from Spreadsheets
  13. SQL Views
  14. Lookup Views
  15. Join Views
  16. Aggregate Views
  17. Business Intelligence and Reporting Tools Reports
  18. Dashboards
  19. DVOCmd Command Line Program
  20. Troubleshooting
  21. Appendix A: Datatype Reference
  22. Appendix B: Reporting Views
  23. Appendix C: Metadata Import Syntax
  24. Appendix D: Jasper Reports
  25. Appendix E: Glossary

Data Validation Option User Guide

Data Validation Option User Guide

Data Validation Process

Data Validation Process

After you determine the validation requirements, you can create and run validation tests from within the Data Validation Client. You can view test results and run reports from within the Data Validation Client.
Use the following process to perform data validation:
  1. Determine the validation requirements.
  2. Optionally, create a data validation view to represent one or more data sources.
  3. Create a table object that contains one or more data sources or views.
  4. Create a test to validate data in the table object.
  5. Run the test.
  6. View test results.

Step 1. Determine the validation requirements.

Before you create a validation test, you first determine the testing requirements. Identify the data sources in the PowerCenter repository that contain data that you need to validate. If the validation is fairly straightforward, you can add the data source or data sources to a table object. If the validation is more complex, you might need to create a view with one or more data sources and then add the view to a table object.

Step 2. Create a data validation view.

You might need to create a data validation view based on an SQL query or based on one or more data sources.
When you create a data validation view, the PowerCenter Integration Service stores the view definition in the Data Validation Option repository. You can edit the view in the Data Validation Client.

Step 3. Create a table object.

After you create a view, you can add it to a table object. Create a table object that contains one or more table definitions or views. You can create a single table object or a table pair object. If you create a single table object, you specify the primary key. If you create a table pair object, you specify the join condition. You can include a WHERE clause to validate a subset of the data.
When you create a table object, the PowerCenter Integration Service stores the object in the Data Validation Option repository.

Step 4. Create a validation test.

After you create a table object, you can create a test based on the object. When you create the test, you choose the type of test that you want to run. You can choose an aggregate, set, or value test type. You configure test conditions based on the type of test that you choose.

Step 5. Run the test.

After you create a validation test, you can run it. When you run a validation test, the PowerCenter Integration Service creates the mapping and run-time objects in the Data Validation Option folder of the PowerCenter repository. It runs the mapping and loads the results into the Data Validation Option repository.

Step 6. View the test results.

After you run a test, you can view the summary of results in the Data Validation Client. You can see if the test passed or failed. The test fails if any row does not meet the validation condition. You can run reports from within the Data Validation Client. You can also view the session log from within the Data Validation Client.