Governance User Guide

3.0.2
- 3.0 HotFix 1

Back Next

Topic Properties

The tables list the properties for the topics in Proactive Monitoring for PowerCenter Governance:

The following table lists the properties for the pc_sessions topic:

Property	Description
session_is_valid	Indicates whether the session status is valid.
session_is_impacted	Indicates whether there is an impact on a session status when a user makes a change in the session.
curr_tstamp	Indicates the current time of event generation.
version_number	Indicates the version number of the PowerCenter session that a user modifies within the incremental time window.
session_last_saved	Indicates the time stamp when the PowerCenter session was last saved within the incremental time window.
workflow_name	Indicates the workflow name of the associated PowerCenter session.
tstamp	Indicates the time stamp when the PowerCenter session was last saved within the incremental time window.
session_id	Indicates the internal ID generated within PowerCenter for the session.
mapping_last_saved	Indicates the last saved time for the mapping associated with the PowerCentre session.
is_reusable	Indicates whether you can reuse the session.
is_enabled	Indicates whether you can enable or disable the session.
session_name	Indicates the name of the PowerCenter session.
mapping_name	Indicates the mapping name associated with the PowerCenter session.
rs	Indicates the Repository Service name associated with the PowerCenter session.
session_comments	Provides the comments in the section content of the session.
folder	Indicates the folder name associated with the session.
domain	Indicates the domain name associated with the session.
user_name	Indicates the name of the user who enforced a change to the PowerCenter session within the incremental time window.

The following table lists the properties for the pc_mapplets topic:

Property	Description
comments	Provides the comments in the section content of the mapplet.
mapplet_name	Indicates the name of the PowerCenter mapplet.
last_saved	Indicates the time stamp when the PowerCenter mapplet was last saved within the incremental time window.
is_valid	Indicates whether the mapplet status is valid.
mapplet_id	Indicates the internal ID generated within PowerCenter for the mapplet.
rs	Indicates the Repository Service name associated with the PowerCenter mapplet.
folder	Indicates the folder name associated with the mapplet.
domain	Indicates the domain name associated with the mapplet.
user_name	Indicates the name of the user who enforced a change to the PowerCenter mapplet within the incremental time window.
version_number	Indicates the version number of the PowerCenter mapplet that a user modifies within the incremental time window.
tstamp	Indicates the time stamp when the PowerCenter mapplet was last saved within the incremental time window.

The following table lists the properties for the pc_worklets topic:

Property	Description
worklet_id	Indicates the internal ID generated within PowerCenter for the worklet.
comments	Provides comments of the PowerCenter worklet.
last_saved	Indicates the time stamp when the PowerCenter worklet was last saved within the incremental time window.
version_number	Indicates the version number of the modified PowerCenter worklet within the incremental time window.
worklet_name	Indicates the name of the PowerCenter worklet.
tstamp	Indicates the time stamp when the PowerCenter worklet was last saved within the incremental time window.
workflow_name	Indicates the workflow name associated with the PowerCenter worklet.
is_valid	Indicates whether the worklet status is valid.
rs	Indicates the Repository Service name associated with the PowerCenter worklet.
folder	Indicates the folder name associated with the PowerCenter worklet.
domain	Indicates the domain name associated with the PowerCenter worklet.
user_name	Indicates the name of the user who enforced a change to the PowerCenter worklet within the incremental time window.

The following table lists the properties for the pc_transforms topic:

Property	Description
mapping_id	Indicates the internal ID generated within PowerCenter for the mapping.
transform_type	Indicates the type of PowerCenter transformation. For example, type can be Source Definition or Target Definition.
last_saved	Indicates the time stamp when the PowerCenter transformation was last saved within the incremental time window.
transform_type_id	Provides the internal ID of the transformation type.
version_number	Indicates the version number of the modified PowerCenter transformation within the incremental time window.
transform_description	Provides the description of the PowerCenter transformation.
transform_name	Indicates the name of the PowerCenter transformation.
transform_id	Indicates the internal ID generated within PowerCenter for the transformation.
tstamp	Indicates the time stamp when the PowerCenter transformation was last saved within the incremental time window.
workflow_name	Indicates the workflow name associated with the PowerCenter transformation.
mapping_name	Indicates the mapping name associated with the PowerCenter transformation.
rs	Indicates the Repository Service name associated with the PowerCenter transformation.
folder	Indicates the folder name associated with the PowerCenter transformation.
domain	Indicates the domain name associated with the PowerCenter transformation.
user_name	Indicates the name of the user who enforced a change to the PowerCenter transformation within the incremental time window.

The following table lists the properties for the pc_mappings topic:

Property	Description
mapping_id	Indicates the internal ID generated within PowerCenter for the mapping.
mapping_is_valid	Indicates whether the mapping status is valid.
version_number	Indicates the version number of the modified PowerCenter mapping within the incremental time window.
tstamp	Indicates the time stamp when the PowerCenter mapping was last saved within the incremental time window.
workflow_name	Indicates the workflow name associated with the PowerCenter mapping.
mapping_name	Indicates the name of this PowerCenter mapping.
rs	Indicates the Repository Service name associated with the PowerCenter mapping.
mapping_last_saved	Indicates the time stamp when the PowerCenter mapping was last saved within the incremental time window.
folder	Indicates the folder name associated with the PowerCenter mapping.
domain	Indicates the domain name associated with the PowerCenter mapping.
mapping_description	Provides the description of the PowerCenter mapping.
user_name	Indicates the name of the user who enforced a change to the PowerCenter mapping within the incremental time window.

Property	Description
mapping_id	Indicates the internal ID generated within PowerCenter for the mapping.
mapping_is_valid	Indicates whether the mapping status is valid.
version_number	Indicates the version number of the modified PowerCenter mapping within the incremental time window.
tstamp	Indicates the time stamp when the PowerCenter mapping was last saved within the incremental time window.
workflow_name	Indicates the workflow name associated with the PowerCenter mapping.
mapping_name	Indicates the name of this PowerCenter mapping.
rs	Indicates the Repository Service name associated with the PowerCenter mapping.
mapping_last_saved	Indicates the time stamp when the PowerCenter mapping was last saved within the incremental time window.
folder	Indicates the folder name associated with the PowerCenter mapping.
domain	Indicates the domain name associated with the PowerCenter mapping.
mapping_description	Provides the description of the PowerCenter mapping.
user_name	Indicates the name of the user who enforced a change to the PowerCenter mapping within the incremental time window.

The following table lists the properties for the pc_workflows topic:

Property	Description
workflow_last_saved	Indicates the time stamp when the PowerCenter workflow was last saved within the incremental time window.
workflow_is_valid	Indicates whether the workflow status is valid.
workflow_is_runnable_service	Indicates whether the workflow is runnable, is valid, and is assigned to an Integration Service that is accessible.
version_number	Indicates the version number of the modified PowerCenter workflow within the incremental time window.
workflow_comments	Provides the comments of the PowerCenter workflow.
workflow_is_service	Indicates whether the workflow is a service workflow. You can only run a service workflow.
workflow_name	Indicates the name of the PowerCenter workflow.
tstamp	Indicates the time stamp when the PowerCenter workflow was last saved within the incremental time window.
rs	Indicates the Repository Service name associated with the PowerCenter workflow.
workflow_id	Indicates the internal ID generated within PowerCenter for the workflow.
folder	Indicates the folder name associated with the PowerCenter workflow.
domain	Indicates the domain name associated with the PowerCenter workflow.
user_name	Indicates the name of the user who enforced a change to the PowerCenter workflow within the incremental time window.

The following table lists the properties for the pc_command_tasks topic:

Property	Description
is_enabled	Indicates whether the command task is enabled.
task_name	Indicates the name of the PowerCenter command task.
version_number	Indicates the version number of the modified PowerCenter command task within the incremental time window.
workflow_name	Indicates the workflow name associated with the PowerCenter command task.
tstamp	Indicates the time stamp when the PowerCenter command task was last saved within the incremental time window.
type	Indicates the type of PowerCenter task. For example, task type can be Session, Command Task, or Start Task.
rs	Indicates the Repository Service name associated with the PowerCenter command task.
task_id	Indicates the internal ID generated within PowerCenter for the command task.
folder	Indicates the folder name associated with the PowerCenter command task.
attribute	Indicates the attribute name associated with the PowerCenter command task.
domain	Indicates the domain name associated with the PowerCenter command task.
user_name	Indicates the name of the user who enforced a change to the PowerCenter command task within the incremental time window.

The following table lists the properties for the pc_running_sessions_workflows_count topic:

Property	Description
is_name	Indicates the Integration Service name associated with the PowerCenter sessions and workflows that are running.
session_cnt	Indicates the number of sessions running within the Informatica domain.
tstamp	Indicates the snapshot time when the count of running sessions and workflows was extracted.
rs	Indicates the Repository Service name associated with the running PowerCenter sessions and worflows.
workflow_cnt	Indicates the number of workflows that run within the Informatica domain.
domain	Indicates the domain name associated with the running PowerCenter sessions and worflows.

Rename Saved Search

Table of Contents

Governance User Guide

Governance User Guide

Topic Properties

Topic Properties