Table of Contents

Search

  1. Preface
  2. Introduction to Data Validation Option
  3. New Features and Behavior Changes
  4. Repositories
  5. XML Data Source
  6. Tests for XML Data Sources
  7. Connections
  8. Expressions
  9. Table Pairs
  10. Tests for Table Pairs
  11. Single-Table Constraints
  12. Tests for Single-Table Constraints
  13. Examples of Tests from Spreadsheets
  14. SQL Views
  15. Lookup Views
  16. Join Views
  17. Aggregate Views
  18. Business Intelligence and Reporting Tools Reports
  19. Dashboards
  20. DVOCmd Command Line Program
  21. Troubleshooting
  22. Datatype Reference
  23. Reporting Views
  24. Metadata Import Syntax
  25. Jasper Reports
  26. Glossary

Data Validation Option User Guide

Data Validation Option User Guide

New Features and Enhancements (9.6.0)

New Features and Enhancements (9.6.0)

This section describes new features and enhancements in version 9.6.0.

Aggregate Views

Effective in 9.6.0, you can use aggregate views to perform aggregation operations before you run table pair and single-table tests. You can use all data sources that Data Validation Option uses as well as lookup views, SQL views, and join views within an aggregate view.

Oracle ASO Database as Data Validation Repository

Effective in 9.6.0, you can use an Oracle database with Oracle Advanced Security (ASO) enabled, as the Data Validation Option repository.

Password Encryption for DVOCmd Commands

You can use the DVOCmd EncryptPassword command to generate an encrypted form of user account passwords and administrator account passwords. You can use the encrypted form of a password in DVOCmd commands.
Instead of using the encrypted form of the password in a DVOCmd command, you can use the environment variable. You can use the environment variable in DVOCmd commands, such as the
CopyFolder
,
DisableInformaticaAuthentication
,
ExportMetadata
,
ImportMetadata
,
InstallTests
,
PurgeRuns
,
LinkDVOUsersToInformatica
,
UpdateInformaticaAuthenticationConfiguration
,
RefreshRepository
, and
RunTests
commands.

Kerberos Support

You can use Data Validation Option in a PowerCenter domain that uses Kerberos authentication.

SAP ABAP Program

Effective in 9.6.0, Data Validation Option provides an option to reuse the ABAP program for table pairs and single tables associated with a SAP source mapping. If you have migrated the ABAP program from the development environment to the production or test environment, then you can reuse that ABAP program in the production or test environment. The
Mapping Properties Preferences
dialog includes a flag for ABAP program and a parameter for the ABAP development class.

Connections

Effective in 9.6.0, Data Validation Option uses a native connection for the following data sources:
  • DB2 AS/400
  • COBOL
  • IMS
    • PWX_IMS_NRDB2
    • PWX_IMS
  • PWX_ADABAS_NRDB2
  • VSAM
    • PWX_VSAM
    • PWX_VSAM_NRDB2
  • Mainframe Flat Files
    • PWX_SEQ_NRDB2

Reporting View Timestamps in Standard Date-Time Format

Effective in 9.6.0, some reporting views include one or more columns that display time in the standard date and time format. For example, the tr_start_time is saved as
1391141528543
in views. This value is read from tr_start_timestamp as
2014-01-31 09:42:08.543
.
The following table lists the reporting views and the columns that display time in standard date and time format:
Reporting View
Columns
results_summary_view
tr_start_timestamp
tr_finish_timestamp
tp_edit_timestamp
results_id_view
tr_start_timestamp
rs_lv_id_view
tr_start_timestamp
rs_jv_id_view
tr_start_timestamp
rs_sv_id_view
tr_start_timestamp
rs_av_id_view
tr_start_timestamp

Details of Bad Records

In Data Validation Option, you can view the details of a bad record for value tests, outer value tests, unique tests, and set tests. To view the details of a bad record, in the Bad Records tab, select
Show Delimiters
or
Show Differences
.
The
Bad Records
tab displays a delimiter before and after each string value to help you identify whitespace in a record of string data type. The
Bad Records
tab displays the difference in value along with the percentage of difference in a record of a numeric data type.

SQL Views

You can edit the connection in the table pairs, single tables, aggregate views, and join views when you use SQL view as the data source.

Table Pair and Single Table Tests

Effective in 9.6.0, when you export a table pair or a test single-table test, the exported spreadsheet has a new worksheet Fields, which includes column name, data type, precision, and scale.
Previously, there was one worksheet with the test details.