Data Validation Option Installation and Configuration Guide

10.5
- 10.5.2
- 10.5.1
- 10.4.0

Back Next

Configure Environment Variables

To apply the environment variable changes, you must restart the Data Validation Client and, if applicable, open a new command-line session.

Configure the following environment variables on the Data Validation Client machine:

DV_CONFIG_DIR: Optional. Location of the DVConfig.properties file. By default, DVConfig.properties file is available in the user configuration directory.
For example DVConfig.properties is available in the following location on a 64-bit Windows machine:
C:\Users\<user name>\DataValidator
DV_DEFAULT_RTRIM_VALUES: Optional. Specify a default setting for the
Trim Trailing Space
option for tests. Set the value to
Y
to trim trailing spaces by default.
If you set the value to
Y
, the
Trim Trailing Space
option is selected by default when you create a test in the
Table Pair Test Editor
dialog box or the
Single Table Test Editor
dialog box.
DV_DOUBLE_COMPARISON_EPSILON: Optional. Set the tolerance value for floating point numbers if you want to test high-precision data. Default is 1e-15. The tolerance value does not affect join keys. The variable applies to the "equal to" operator only.
DV_MAPPING_STRING_MAX_PRECISION: Optional. Set the maximum precision for string fields in the Data Validation Option mappings. Valid values are whole numbers greater than 0. The maximum value depends on the String data type in the database. If you do not set the environment variable, Data Validation Option retains the precision set in PowerCenter.
DV_RTRIM_JOIN_KEYS: Optional. Set the trailing space setting for join keys. Set the value to "Y" to remove the trailing spaces from join keys. Set the value to "N" to retain the trailing spaces. If you do not set the environment variable, Data Validation Option retains the trailing spaces.
DV_TREAT_EMPTY_STRING_AS_NULL: Optional. Set to indicate that a null value and an empty string are equal when Data Validation Option compares the values of fields in an Oracle database. If you do not set this environment variable and Data Validation Option compares two fields where one is null and the other has an empty value, Data Validation Option considers the values as not equal.
DVO_PC_VERSION: If you use Informatica authentication with version 10.2, set
10.2.0
as the value for the environment variable. If you use Informatica authentication with version 10.2 HotFix 2, set
10.2.0.2
as the value for the environment variable. If you use Informatica authentication with version 10.4, set
10.4.0
as the value for the environment variable. If you use Informatica authentication with version 10.5, set
10.5.0
as the value for the environment variable.
INFA_DOMAINS_FILE: Set to the following location of the domains.infa file on the Data Validation Client machine:
$INFA_HOME/domains.infa
INFA_HOME: Required. Set the INFA_HOME environment variable to the PowerCenter Client installation directory.
INFA_TRUSTSTORE: The variable points to the directory that contains the trust store files for the SSL certificates. The directory must contain trust store files named infa_truststore.jks and infa_truststore.pem.
INFA_TRUSTSTORE_PASSWORD: Required if you access a domain version that has custom SSL certificate.
KRB5_CONFIG: Required. Use the KRB5_CONFIG environment variable to store the path and file name of the Kerberos configuration file. The name of the Kerberos configuration file is krb5.conf. You must set the KRB5_CONFIG environment variable on each machine that hosts an Informatica client.

Set the variable to the following value:

$INFA_HOME/services/shared/security/krb5.conf

Rename Saved Search

Table of Contents

Data Validation Option Installation and Configuration Guide

Data Validation Option Installation and Configuration Guide

Configure Environment Variables

Configure Environment Variables