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

Bad Records in Flat File

Bad Records in Flat File

If you configure to store bad records in flat file, Data Validation Option creates the flat file in the machine that runs Informatica services.
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 modify the folder from the Administrator tool. Edit the $PMTargetFileDir property for the PowerCenter Integration Service.
Data Validation Option generates a folder for each of the table pair or single table. The name of the table pair or single table is in the following format:
TablePairName_TestRunID or SingleTableName_TestRunID
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_TestCaseColumnB_TestCaseIndex.<user defined file extension>
You can get the Test Case Index from the Properties tab and the Test Run ID from the results summary of the test in the detail area. You can get the Table Pair ID/Single Table ID from the Table Pair or Single Table properties.
For example, you enter the file name as BAD_ROWS.txt when you configure the table pair or single table and you run an outer value test on fields FIRSTNAME and FIRSTNAME. The test-case index is 1 and the test-fields are expressions. The bad records file after you run the test is of the format, BAD_ROWS_OUTER_VALUE_ExprA_ExprB_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. You must not use comma as a file delimiter.
When you run the tests for the table pair or single table, Data Validation Option stores the details of the bad records along with the following format:
Table Pair Name Table A Name Table A Connection Table B Name Table B Connection Test Definition Test Run Time Test Run By User Key A[],Result A[],Key B[],Result B[]
If the tests pass, Data Validation Option still creates a flat file without any bad records information.