Table of Contents

Search

  1. Preface
  2. Introduction to Informatica Data Engineering Integration
  3. Mappings
  4. Mapping Optimization
  5. Sources
  6. Targets
  7. Transformations
  8. Python Transformation
  9. Data Preview
  10. Cluster Workflows
  11. Profiles
  12. Monitoring
  13. Hierarchical Data Processing
  14. Hierarchical Data Processing Configuration
  15. Hierarchical Data Processing with Schema Changes
  16. Intelligent Structure Models
  17. Blockchain
  18. Stateful Computing
  19. Appendix A: Connections Reference
  20. Appendix B: Data Type Reference
  21. Appendix C: Function Reference

Step 3. Configure a Storage Location

Step 3. Configure a Storage Location

Set a storage location for the audit results before you run a mapping with audit rules and conditions.
Configure the storage location in the mapping audit properties. You can store the results in a local file, a database that uses a JDBC connection, or both.
Configure local file storage
To store the results in a local file, configure the following properties:
  • File directory.
    Local directory to store results file.
  • File name.
    Name of the file to store the results. If the file does not exist, it is created at run time.
  • Append.
    Select this option to append the results to an existing file. If you do not choose to append the results, the Data Integration Service overwrites any results in the file when the mapping runs.
Configure JDBC connection storage
To store the results in a database that uses a JDBC connection, perform the following steps:
  1. Verify that you have a JDBC connection defined for the database where you want to store the audit results.
  2. Create the resource table to store the results. Use the following schema to create the table:
    CREATE TABLE <table name> ( RULE_NAME VARCHAR2 (128), RESULT VARCHAR2 (128), EXECUTION_ID VARCHAR2 (128), DIS_NAME VARCHAR2 (128), USER_NAME VARCHAR2 (128), MAPPING_NAME VARCHAR2 (128), TIMESTAMP VARCHAR2 (29) )
  3. Configure the following connection storage properties:
    • Connection.
      Select the JDBC connection.
    • Owner.
      Name of the database that includes the table.
    • Resource.
      Name of the table you created to store the results.
To clear the local file storage configuration, click the
File storage
clear button. To clear the JDBC connection storage configuration, click the
Database storage
clear button. The following image shows these buttons: Screenshot of the Audit mapping properties in the Developer tool. A sample rule is configured, as well as file storage and database storage. The Clear File Storage and Clear Database Storage buttons are highlighted in a red rectangle.


Updated March 31, 2021