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 Replication 9.7.0 HotFix 1
  • All Products

Table of Contents

Search

  1. Preface
  2. Data Replication Overview
  3. Understanding Data Replication
  4. Sources - Preparation and Replication Considerations
  5. Targets - Preparation and Replication Considerations
  6. Starting the Server Manager
  7. Getting Started with the Data Replication Console
  8. Defining and Managing Server Manager Main Servers and Subservers
  9. Creating and Managing User Accounts
  10. Creating and Managing Connections
  11. Creating Replication Configurations
  12. Materializing Targets with InitialSync
  13. Scheduling and Running Replication Tasks
  14. Implementing Advanced Replication Topologies
  15. Monitoring Data Replication
  16. Managing Replication Configurations
  17. Handling Replication Environment Changes and Failures
  18. Troubleshooting
  19. Data Replication Files and Subdirectories
  20. Data Replication Runtime Parameters
  21. Command Line Parameters for Data Replication Components
  22. Updating Configurations in the Replication Configuration CLI
  23. DDL Statements for Manually Creating Recovery Tables
  24. Sample Scripts for Enabling or Disabling SQL Server Change Data Capture
  25. Glossary

User Guide

User Guide

Back Next

Viewing a Specific Intermediate File Directly

Viewing a Specific Intermediate File Directly

In the Data Replication Console, you can view the content of the .dat and .trn files that comprise a specific intermediate file directly, without drilling down from a configuration. This feature is primarily for use by the Data Replication administrator and Informatica Global Customer Support.
  1. Click
    Tools
    View Intermediate File
    .
    The
    Open Intermediate File
     dialog box appears:
    The Open Intermediate File dialog box contains the following fields: Server, Intermediate File, Configuration, and Database Type.
  2. In the
    Server
     list, select the Server Manager instance that stores intermediate files.
  3. In the
    Intermediate File
     field, enter the full path to the intermediate file that you want to view or click the
    Browse
     button to browse to the intermediate file.
  4. Optionally, in the
    Configuration
     field, enter the full path to the configuration SQLite database or click the
    Browse
     button to browse to the configuration SQLite database.
    The Data Replication Console requires a configuration SQLite database to decrypt encrypted intermediate files and to translate table and column identifiers that are used in intermediate files into table and column names. If you do not specify a configuration SQLite database for an encrypted intermediate file, the Data Replication Console cannot read the intermediate file. If you do not specify a configuration SQLite database for an intermediate file that is not encrypted, the table and column names on the
    Intermediate File Information
     window will contain empty values.
  5. In the
    Database type
     list, select the source database type.
  6. Click
    OK
    .
    The
    Intermediate File Information
     window appears:
    The Intermediate File Information window contains the list of records in the upper box and the list of old and new column values for a selected record in the lower box.
    The upper list box lists the intermediate file records that match the selected record type and date range. When you select an intermediate file record, the
    Columns
     list box lists the columns for that record and any changes to the column value and size. For Update records, unchanged columns are indicated by gray shading in the
    New Value
     and
    New Size
     cells. For more information, see Change Record Information in Intermediate Files.
  7. Click
    Data
     to view records in the .dat file, or click
    Transactions
     to view records in the corresponding .trn file.
    For more information about these records, see Change Record Information for Intermediate Files.
  8. To filter change records, enter one or more of the following filter criteria:
    • In the
      Records
       field, select one or more of the
      Insert
      ,
      Update
      , and
      Delete
       check boxes to filter records by the DML operation type.
    • In the
      Other types
       list, select other record types.
    • To filter records by transaction ID, enter the transaction ID in the
      Filter by Xid
       box and then press Enter.
      To copy a transaction ID to the
      Filter by Xid
       field, select a record row in the upper list box, right-click the row, and click
      Filter by Xid
      .
    • To filter records by date and time, select the check box that precedes the
      From
       and
      to
       fields and enter date and time values in these fields. Then click
      Show
      .
    • To filter records by minimum and maximum SCN values, enter SCN values in the
      Filter by min SCN
       and
      Filter by max SCN
       fields and then press Enter.
      To copy an SCN value to the
      Filter by min SCN
       or
      Filter by max SCN
       field, select a record row in the upper list box, right-click the row, and then click one of the following options:
      • Filter by min SCN
        . Copies the SCN value to the
        Filter by min SCN
         field.
      • Filter by max SCN
        . Copies the SCN value to the
        Filter by max SCN
         field.
      • Filter by SCN
        . Copies the SCN value to the
        Filter by min SCN
         and
        Filter by max SCN
         fields.
  9. To open the preceding or next intermediate file, click
    Back
     or
    Next
    .
  10. When you are finished, click
    Close
    .
0 COMMENTS
We’d like to hear from you!