Table of Contents

Search

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

Data Validation Option User Guide

Data Validation Option User Guide

RunTests

RunTests

Runs all tests for one or more single-table objects or table-pair objects. You can run this command on Windows or UNIX.
For example, to run tests for a table pair with the external ID "abc123," enter the following command:
DVOCmd RunTests abc123
The
RunTests
command uses the following syntax:
DVOCmd RunTests external_ID [external_ID …] [--confdir conf_dir] [--username User name] [--password Password] [--ePassword Password Environment Variable] [--namespace Namespace] [--email email_ID,...] [--sendEmail NotPass] [--cacheSize CACHESIZE] [--folderNames]
The following table describes
RunTests
options and arguments:
Option
Argument
Description
-
external_ID
Required if you do not use folderNames.
External ID of a single-table object or a table-pair object. You can separate multiple external IDs with spaces.
If the folder name or external ID contains commas, spaces, or special characters, you will need to use different syntax.
--confdir
conf_dir
The user configuration directory. Specify the configuration directory if you have multiple Data Validation Option repositories on a client machine. If you have one Data Validation Option repository on a client machine and have not changed the configuration directory, you do not need to specify this option.
Enclose the file path in quotes.
--username
User name
User name in the Informatica domain for which you configured Informatica authentication.
Required if you configure Informatica authentication.
--password
Password
Password for the user name.
Required if you configure Informatica authentication.
If you set the password option, then do not set the ePassword option.
--ePassword
Password Environment Variable
Encrypted form of the password of the Informatica user name.
Use the DVOCmd EncryptPassword command to encrypt the password. Set an environment variable to the encrypted password and use the variable in the ePassword option. The command replaces the environment variable with the encrypted password and then decrypts the password.
If you set the ePassword option, then do not set the password option. If the command contains both the password and ePassword options, then the Data Validation Option uses the ePassword and ignores the password.
--namespace
Namespace
Namespace of the LDAP domain.
Required if you configure Informatica Authentication and the domain uses LDAP authentication.
--email
email_ID
The email address to which Data Validation Option sends an email when the tests complete. You can provide multiple email addresses separated by commas. The email provides a link to the test results and specifies whether the tests pass or fail.
If the PowerCenter Integration Service is running on Windows, configure the outgoing mail server with the following custom properties: SMTPServerAddress, SMTPPortNumber, SMTPFromAddress, and SMTPServerTimeout. To send mail with Microsoft Outlook, enter the Microsoft Exchange profile in the MSExchangeProfile configuration property in the PowerCenter Integration Service.
--sendEmail
NotPass
Data Validation Option sends an email if a test fails.
--cacheSize
CACHESIZE
Memory allocation to generate transformations in PowerCenter mappings. Increase the cache size for tests that contain multiple joins and lookups.
Default is 20 MB for the data cache and 10 MB for the index cache.
Specify "Auto" to enable PowerCenter to compute the cache size.
When you run the RunTests command and set the cache size, Data Validation Option installs the tests in the repository before it runs the test.
--folderNames
folderA
Required if you do not use external_ID.
Runs all objects in the specified folders.
Separate multiple folder names with commas
If your folder name or external ID contains commas, spaces, or special characters, you must use different syntax.
If the folders have a large number of objects, the PowerCenter Integration Service places them in a queue to run. The PowerCenter Integration Service limits the number of sessions that can run concurrently based on the Max Concurrent Runs property configured in the Data Validation preferences.
The DVOCmd RunTests command returns the following output:
ERROR: TablePairs: <number>; Pass: <number>; Fail: <number>; No Result: <number>; Install/Run error: <number>.
The following table describes the output:
Output
Description
TablePairs
Number of table-pair objects or single-table objects that you run in the RunTests command.
Pass
Number of table-pair objects or single-table objects for which all tests completed successfully.
Fail
Number of table-pair objects or single-table objects for which at least one test failed.
No Result
Number of table-pair objects that returned no matching records based on the table join.
Install/Run Error
Number of table-pair objects or single-table objects for which Data Validation Option could not generate or install mappings successfully.
If you run the DVOCmd RunTests command from a shell script or batch file, the command returns a return code. For example, the command returns the return code to the %errorlevel% environment variable on Windows. The return code represents the status of all tests that the DVOCmd RunTests command runs. If you run tests for multiple single-table objects or table-pair objects, the return code applies to all tests for all single-table objects or all table-pair objects.
The following table describes the possible return codes for the DVOCmd RunTests command:
Return Code
Description
0
All tests are successful.
1
At least one test fails. A test fails if it fails to install, fails to run, does not return any result, or does not meet the test condition.