Option	Description
-d	The name of the database to process. Add the option to perform validation at the database level.
-s	The name of the schema in the database to process. Default is all schemas. Add the option to perform validation at the schema level.
-t	The name of the table in the schema to process. Add the option to perform validation at the table level. Default is all tables. To validate at the table level, you must include options -d and -s. For example, on connected servers: ssadatavalidation.exe -h INKW12DSG462 -p 3300 -q 3400 -u dba/dba -H INVW16DSG1298 -P 3300 -Q 3400 -U dba/dba -r "C:\IDV" -a 1 -v 0 -R 1 -m 5 -d TEST_DATABASE1 -s TEST_SCHEMA1 -t TEST_TABLE1 On unconnected servers: ssadatavalidation.exe -i 1 -h INKW12DSG462-p 3300 -q 3400 -r "C:\INKW12DSG462" -u dba/dba -a 1 -v 0 -R 1 -m 4 -d TEST_DATABASE1 -s TEST_SCHEMA1 -t TEST_TABLE1
-v[0,1]	Enables or disables validation at the column level. Default is 0. Enter 1 to enable. For example, on connected servers: ssadatavalidation.exe -h INKW12DSG462 -p 3300 -q 3400 -u dba/dba -H INVW16DSG1298 -P 3300 -Q 3400 -U dba/dba -r "C:\IDV" -a 1 -v 1 -R 1 -m 5 On unconnected servers: ssadatavalidation.exe -i 1 -h INKW12DSG462-p 3300 -q 3400 -r "C:\INKW12DSG462" -u dba/dba -a 1 -v 1 -R 1 -m 4 The value of option -v must be the same when you run the utility on each server.
-n nnn	The number of rows in each partition. Requires the -v option. Default is 20000. For example: ssadatavalidation.exe -h INKW12DSG462 -p 3300 -q 3400 -u dba/dba -H INVW16DSG1298 -P 3300 -Q 3400 -U dba/dba -r "C:\IDV" -a 1 -R 0 -m 5 -n 30000 -v 1
-k[0,1]	Retain temporary files. Default is 0. For example, on connected servers: ssadatavalidation.exe -h INKW12DSG462 -p 3300 -q 3400 -u dba/dba -H INVW16DSG1298 -P 3300 -Q 3400 -U dba/dba -r "C:\IDV" -a 1 -v 0 -R 1 -m 5 -k 1 On unconnected servers: Server 1 ssadatavalidation.exe -i 1 -h INKW12DSG462.informatica.com -p 3300 -q 3400 -r "C:\INKW12DSG462" -u dba/dba -a 1 -v 0 -R 1 -m 5 -k 1 Server 2 ssadatavalidation.exe -i 1 -H INVW16DSG1298.informatica.com -P 3300 -Q 3400 -r "C:\INVW16DSG1298" -U dba/dba -a 1 -v 0 -R 1 -m 5 -k 1
-o[0,1]	Records differences in a diff file corresponding to a table. Set the option to 0 to record only the first difference that occurs. Set the option to 1 to record all differences. Default is 0. Use if column data validation identifies deviations. To set the option, you must include options -d and -s.

If you run the utility for a table or column that includes special characters in the name on a Windows environment, enter the table and column names in double quotes. Verify that Informatica Data Vault supports the special characters.

For example, on connected servers:

ssadatavalidation.exe -h INKW12DSG462 -p 3300 -q 3400
-u dba/dba -H INVW16DSG1298 -P 3300 -Q 3400
-U dba/dba -r "C:\IDV" -a 1 -v 0 -R 1 -m 5 -d TEST_DATABASE1
-s TEST_SCHEMA1
-t “A_B$C~D!E@F^G&H-I+J=K:L<M>N?O|Q{R}”
-c “A_B$C~D!E@F^G&H-I+J=K:L<M>N?O|Q{R}”

On unconnected servers:

ssadatavalidation.exe -i 1 -h INKW12DSG462-p 3300 -q 3400 -r "C:\INKW12DSG462" 
-u dba/dba -a 1 -v 0 -R 1 -m 4 -d TEST_DATABASE1 -s TEST_SCHEMA1 
-t “A_B$C~D!E@F^G&H-I+J=K:L<M>N?O|Q{R}” -c “A_B$C~D!E@F^G&H-I+J=K:L<M>N?O|Q{R}”

Add the following options to run the utility:

Option	Description
-x	The absolute path of the certificate file for server 1.
-X	The absolute path of the certificate file for server 2.

If you run the utility from the target machine, the Truststore files must be copied from the source machine to the target machine.

If you run the utility from the source machine, copy the target certificate to the source machine and then import into cacerts on the source machine. If you run the utility from the target machine, copy the source certificate to the target machine and then import into cacerts on the target machine.

For example:

keytool -importcert -file mycertfile.pem -keystore cacerts -alias "Alias"

ssadatavalidation.exe -h INKW12DSG462 -p 3300 -q 3400 -u dba/dba
 -H INVW16DSG1298 -P 3300 -Q 3400 -U dba/dba -r "C:\IDV"
-a 1 -v 0 -R 1 -m 5 -x “C:\OpenSSL\bin\private_cert.pem”
-X “D:\OpenSSL\bin\private_cert.pem”

When you create the certificates, you must provide the -h and -H options with the common name.

Add the following options to run the utility:

Option	Description
-x	The absolute path of the certificate file for server 1.
-X	The absolute path of the certificate file for server 2.

For example:

Server 1

ssadatavalidation.exe -i 1 -h INKW12DSG462.informatica.com
 -p 3300 -q 3400 -r "C:\INKW12DSG462" -u dba/dba 
-a 1 -v 0 -R 1 -m 5 -x “C:\OpenSSL\bin\private_cert.pem”

Server 2

ssadatavalidation.exe -i 1 -H INVW16DSG1298.informatica.com 
-P 3300 -Q 3400 -r "C:\INVW16DSG1298" -U dba/dba
-a 1 -v 0 -R 1 -m 5 -X “C:\OpenSSL\bin\private_cert.pem”