Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.
Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Data Validation
  • All Products

Table of Contents

Search

  1. Preface
  2. Monitoring test cases

Monitor

Monitor

Back Next

Viewing a job report

Viewing a job report

You can view job reports on the job report page. You can open the job report page from the test case details page or from a test suite.
  1. To open a job report from the test case details page, perform the following tasks:
    • On the
      Recent Test Cases
       panel of the
      Home
       page , or on the
      Explore
       page, click a test case.
      The test case details page opens.
    • On the test case details page, select the
      Jobs
       tab and navigate to the row that contains the test case job. On the
      Report
       column, click
      View
      .
      The report page opens.
  2. To open a job report from a test suite, perform the following tasks:
    • On the
      Explore
       page, click a test suite.
    • Click the
      Test Suite Report
       tab.
      Data Validation
       generates a test suite report that displays the most recent test case jobs.
    • Navigate to the row that contains the test case job. On the
      Report
       column, click
      View
      .
      The report page opens.
  3. In the
    Column Matching Status
     area, select
    See data type match result
    .
    The data type match results appear. The following image shows the report page of a test case job with the data type match results:
    In the Test Sequence Details area, the report page shows 11 total records in Connection 1, 17 total records in Connection 2, six total records matched, five total records unmatched, six extra records in Connection 2, and two missing record in Connection 2. In the Row Count area, the row count result is mismatch. In the Column Matching Status area, the column matching status shows six columns.
  4. Expand the
    Detailed Report
     area to view data of missing, unmatched, and extra records in the job results.
    The following image shows the
    Unmatched Records
     tab in the
    Detailed Report
     area of the report page:
    The Unmatched Records tab in the Detailed Report area of the report page shows two unmatched records in the Connection 2 table. The Connection 2 table shows the name, index, altitude, bearing, rev, agency ID, region ID, accuracy, creation date, type, waze distribution, and client ID of each unmatched record.
    If the tables that you compare contain duplicate records,
    Data Validation
     includes the duplicate records in the matched records count.
0 COMMENTS
We’d like to hear from you!