The flat files that Data Validation Option generates after running the tests are stored in the following folder:
<PowerCenter installation directory>\server\infa_shared\TgtFiles
You can edit the folder name in the Administration tool. Modify the $PMTarget variable in the PowerCenter Integration Service.
Data Validation Option generates a folder for each of the single table. The name of the single table is in the following format:
Data Validation Option creates flat files for each test inside the folder. The name of the flat file is in the following format:
<user defined file name>_ TestCaseType_TestCaseColumn A_TestCaseIndex.<user defined file extension>
Suppose you enter the file name as BAD_ROWS.txt when you configure the single table and you run an value constraint test on field SSID. The test-case index is 1. The bad records file after you run the test is of the format, BAD_ROWS_VALUE_CONSTRAINT_SSID_1.txt.
Data Validation Option supports all the file delimiters that PowerCenter supports. When you enter non-printable characters as delimiters, you should enter the corresponding delimiter code in PowerCenter. When you import these files in PowerCenter, you have to manually create the different data fields since the code appears in the place of delimiter in the bad records file.
Data Validation Option uses comma as a delimiter if there a multiple primary keys. Do not use comma as a file delimiter.
When you run the tests for the single table, Data Validation Option stores the details of the bad records along with the following format:
single table Name
Table A Name
Table A Connection
Test Run Time
Test Run By User
Key A,Result A