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

InstallTests

InstallTests

Prepares all tests for single table objects or table pair objects. For each test, this command generates the PowerCenter mapping in the Data Validation Option target folder in the PowerCenter repository. You can run this command on Windows or UNIX.
The InstallTests command uses the following syntax:
DVOCmd InstallTests external_ID [external_ID …] [--confdir conf_dir] [--username User name] [--password Password] [--ePassword Password Environment Variable] [--namespace Namespace] [--cacheSize CACHESIZE] [--forceInstall] [--folderNames]
The following table describes InstallTests options and arguments:
Option
Argument
Description
-
external_ID
Required if you do not use folderNames.
The 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
Informatica domain administrator user name for the domain to which you configured Informatica authentication.
Required if you configure Informatica authentication.
--password
Password
Password for the Informatica 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 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 with LDAP domain.
--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.
--forceInstall
-
Creates mappings for table pair objects in the repository.
DVOCmd uses the DTM buffer size value configured in preferences.xml. If you modify the DTM buffer size value in the preferences file, run the InstallTests command with the forceInstall option for existing table-pair objects before you run the RunTests command.
--folderNames
folderA
Required if you do not use external_ID.
Prepares all objects in the specified folders.
You can separate multiple folder names with commas.
If your folder name or external ID contains commas, spaces, or special characters, you must use different syntax.