Table of Contents

Search

  1. Preface
  2. Understanding Domains
  3. Managing Your Account
  4. Using Informatica Administrator
  5. Using the Domain View
  6. Domain Management
  7. Nodes
  8. High Availability
  9. Connections
  10. Connection Properties
  11. Schedules
  12. Domain Object Export and Import
  13. License Management
  14. Monitoring
  15. Log Management
  16. Domain Reports
  17. Node Diagnostics
  18. Understanding Globalization
  19. Managing Distribution Packages
  20. Appendix A: Code Pages
  21. Appendix B: Custom Roles
  22. Appendix C: Informatica Platform Connectivity
  23. Appendix D: Configure the Web Browser

Administrator Guide

Administrator Guide

Virtual Tables View for an SQL Data Service

Virtual Tables View for an SQL Data Service

The
Virtual Tables
view displays properties about the virtual tables in the SQL data service.
The view shows properties about the virtual tables, such as the name and description. When you select a virtual table in the contents panel, you can view the
Properties
view and
Cache Refresh Runs
view in the details panel.
Properties View
The
Properties
view displays general information and run-time statistics about the selected virtual table. General properties include the virtual table name and the schema name. Monitoring statistics include the number of request, the number of rows cached, and the last cache refresh time.
Cache Refresh Runs View
The
Cache Refresh Runs
view displays cache information for the selected virtual table. The view includes the cache run ID, the request count, row count, and the cache hit rate. The cache hit rate is the total number of requests on the cache divided by the total number of requests for the data object.

0 COMMENTS

We’d like to hear from you!