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.2
  • All Products

Table of Contents

Search

  1. Preface
  2. Proactive Monitoring for PowerCenter Operations
  3. Monitoring PowerCenter Operations
  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. Appendix A: Troubleshooting
  13. Appendix B: Topic Properties Reference
  14. Appendix C: Frequently Asked Questions
  15. Appendix D: Glossary

Operations User Guide

Operations 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 Operations
:
Name
Connects to...
Analytic Type
Description
State
get_lp_pc_completed_sessions_csv
RulePoint Repository
SQL
Fetch completed sessions data for reporting purposes
Deployed
get_lp_pc_completed_workflows_csv
RulePoint Repository
SQL
Fetch completed workflows data for reporting purposes.
Deployed
get_no_mapping
PowerCenter Repository
SQL
Obtain the total number of PowerCenter mappings.
Deployed
get_no_rows_lp_pc_completed_sessions
RulePoint Repository
SQL
Get the number of rows from the completed sessions table in the Proactive Monitoring database. This is used by the Persistence Framework.
Deployed
get_no_rows_lp_pc_completed_workflows
RulePoint Repository
SQL
Get the number of rows from the completed workflows table in the Proactive Monitoring database. This is used by the Persistence Framework.
Deployed
get_no_session
PowerCenter Repository
SQL
Obtain the total number of PowerCenter sessions.
Deployed
get_no_transformation
PowerCenter Repository
SQL
Obtain the total number of PowerCenter sessions.
Deployed
get_no_workflow
PowerCenter Repository
SQL
Obtain the total number of PowerCenter workflows.
Deployed
get_previous_no_of_completed_sessions
PowerCenter Repository
SQL
Obtain the total number of preceding runs for a specified PowerCenter session that is completed.
Deployed
get_previous_no_of_completed_workflows
PowerCenter Repository
SQL
Obtain the total number of preceding runs for a specified PowerCenter workflow that is completed.
Deployed
get_running_sessions_count_csv
PowerCenter Repository
PMPC SQL Analytic
Fetch the count for running sessions under a repository at a given point in time, in the csv format
Draft
get_service_resource_stats
RulePoint Repository
PMPC Service Statistics Analytic
Fetches the environment resource stats for PowerCenter node.
Deployed
get_tstamp_aggregated_analytic
RulePoint Repository
SQL
Obtains the time stamp of PowerCenter Metadata Counts.
Deployed
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_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 is specified in the alerts.
Deployed
pc_get_rtam
RulePoint Repository
SQL
Obtain the
Real-Time Alert Manager
 target for a specified recipient of an alert.
Deployed
pc_get_session_count_for_workflow
PowerCenter Repository
PMPC SQL Analytic
Retrieve the number of sessions in a PowerCenter workflow.
Deployed
pc_getPrevNSessionRows
PowerCenter Repository
SQL
Fetch the number of rows loaded in the previous N runs for a specified PowerCenter session.
Deployed
pc_getPrevNSessionTimes
PowerCenter Repository
SQL
Obtain the elapsed time for the previous N runs for a specified PowerCenter session.
Deployed
pc_getPrevNThroughputs
PowerCenter Repository
PMPC SQL Analytic
Fetch the throughput of target for the previous N runs for a specified PowerCenter session.
Draft
pc_getPrevNWorkflowTimes
PowerCenter Repository
SQL
Fetch the elapsed time for the previous N runs for a specified PowerCenter workflow.
Deployed
pc_is_workflow_running
PowerCenter Repository
PMPC SQL Analytic
Obtain the current running status of PowerCenter workflow in a folder.
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
rs_formatter
Rulepoint Repository
SQL
Format the rs value in the notification response.
Deployed
compare_filefolder_stats
RulePoint Repository
PMPC File-Folder Monitoring Analytic
Fetch the file and folder statistics for the PowerCenter node.
Draft
0 COMMENTS
We’d like to hear from you!