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
  • Informatica Proactive Monitoring 3.0 HotFix 1
  • All Products

Table of Contents

Search

  1. Preface
  2. Proactive Monitoring for PowerCenter Governance Overview
  3. Monitoring PowerCenter Governance
  4. Manage Objects
  5. Proactive Monitoring Reports
  6. Proactive Monitoring SNMP Alerts
  7. Proactive Monitoring Watchlists
  8. Proactive Monitoring Topics
  9. Proactive Monitoring Services
  10. Proactive Monitoring Templates and Rules
  11. Proactive Monitoring Responses
  12. Troubleshooting
  13. Topic Properties Reference
  14. Frequently Asked Questions
  15. Glossary

Governance User Guide

Governance User Guide

Back Next

Analytics

Analytics

RulePoint analytics implement a data processing function, and it can be referenced in rule activations.
The following table lists the predefined analytics that are available by default after installing
Proactive Monitoring for PowerCenter Governance
:
Name
Connects to...
Analytic Type
Description
State
pc_get_alert_history_csv
RulePoint Repository
SQL
Obtain alert history for the previous N days for reporting purposes.
Deployed
pc_get_alert_history_purge_count
RulePoint Repository
SQL
Obtain the count of alert history records to be purged.
Deployed
pc_get_email
RulePoint Repository
SQL
Obtain the email address for a specified recipient of an alert.
Deployed
pc_get_rtam
RulePoint Repository
SQL
Obtain the
Real-Time Alert Manager
 target for a specified recipient of an alert.
Deployed
pc_get_global_setting
RulePoint Repository
SQL
Obtain value from the global settings framework for a specified attribute name.
Deployed
pc_get_purge_cutoff_date
RulePoint Repository
SQL
Obtain the text string for the cutoff date. The cutoff date will be specified in the alerts.
Deployed
pc_recent_alert
Rulepoint Repository
SQL
Check if a recent alert has been sent for a specific rule name, key-value combination, and a snooze interval. The snooze parameter determines the most recent alert.
Deployed
pc_is_mapping_duplicate
PowerCenter Repository
PMPC SQL Analytic
Obtain the duplicates of a specified mapping in all other folders.
Deployed
pc_is_session_duplicate
PowerCenter Repository
PMPC SQL Analytic
Obtain the duplicates of a specified session in all other folders.
Deployed
pc_is_workflow_duplicate
PowerCenter Repository
PMPC SQL Analytic
Obtain the duplicates of a specified workflow in all other folders.
Deployed
pc_get_session_details_for_mapping
PowerCenter Repository
PMPC SQL Analytic
Obtain PowerCenter session details corresponding to the specified mapping.
Draft
pc_get_session_attribute
PowerCenter Repository
PMPC SQL Analytic
Obtain the value for a specified session attribute name.
Deployed
pc_get_session_attribute_count
PowerCenter Repository
PMPC SQL Analytic
Obtain count for a specified session attribute name and value.
Draft
pc_get_workflow_attribute
PowerCenter Repository
PMPC SQL Analytic
Obtain the workflow attribute for a specified workflow.
Deployed
pc_get_workflow_attribute_count
PowerCenter Repository
PMPC SQL Analytic
Obtain the number of workflows for a specified attribute value.
Draft
pc_get_transform_attribute
PowerCenter Repository
PMPC SQL Analytic
Obtain the value for a specified transformation attribute.
Deployed
pc_get_transform_attribute_count
PowerCenter Repository
PMPC SQL Analytic
Obtain the number of transformations for a specified attribute value.
Draft
pc_get_session_mapping_attribute
PowerCenter Repository
PMPC SQL Analytic
Obtain the mapping attributes for a specified session.
Deployed
pc_get_task_parent_failure_options
PowerCenter Repository
PMPC SQL Analytic
Obtain the value of failed parent task option for a specified session.
Deployed
pc_is_session_on_test_load
PowerCenter Repository
PMPC SQL Analytic
Check if a session has the Enable Test Load attribute set.
Draft
rs_formatter
RulePoint Repository
SQL
This formats the rs value in the notification response.
Deployed
get_mapping_ports
PowerCenter Repository
PMPC SQL Analytic
Return all the transformation ports that do not meet the port naming criteria within a mapping.
Draft
get_session_hardcoded_paths
PowerCenter Repository
PMPC SQL Analytic
Return all hardcoded paths configured for sources and targets within a session.
Draft
0 COMMENTS
We’d like to hear from you!