Repository Guide

10.5
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5.1
- 10.4.0

Back Next

Workflow, Worklet, and Task Views

Workflow, worklet, and task views provide both static and run time details about all workflows and worklets created in each folder in a PowerCenter repository.

These views provide information about worklets and sessions inside a workflow. The views also provide information about events, schedules, tasks, connections, and metadata extensions associated with a workflow or a worklet; workflow and worklet execution details such as start time, end time, and the Integration Service on which a workflow or worklet runs and its run status.

Task views provide both static and run time details about tasks such as sessions created in each folder of a PowerCenter repository. These views provide information such as the validity of a session, creation date, sources and targets defined in a session, session connections, and metadata extensions associated with a session. These views also give information about session runtime details like start time, end time, and run status.

The following table lists the different views that help you analyze workflow, worklet, and task metadata:

View	Description
REP_WORKFLOWS	This view contains information about individual workflows and workflow scheduling.
REP_ALL_TASKS	This view provides a list of all reusable and non-reusable tasks that can be used by a workflow or a worklet.
REP_ALL_SCHEDULERS	This view displays a list of schedulers by folder.
REP_WFLOW_VAR	This view displays a list of all variables declared within a workflow or worklet.
REP_EVENT	This view displays the details of events created at the workflow or worklet level.
REP_TASK_INST	This view displays all task instances within workflows and worklets.
REP_WORKFLOW_DEP	This view shows how individual tasks and worklets are connected within a worklet or a workflow.
REP_TASK_INST_RUN	This view displays the run statistics and folder reference for tasks within a workflow or worklet.
REP_WFLOW_RUN	This view displays the run statistics for all workflows by folder.
REP_LOAD_SESSIONS	This view provides information about sessions in the repository.
REP_SESSION_CNXS	This view contains information about connections associated with reusable sessions.
REP_SESSION_INSTANCES	This view contains connection information for session instances.
REP_SESSION_FILES	This view contains file connections associated with reusable sessions.
REP_SESSION_INST_FILES	This view contains file connection information for session instances associated with workflows.
REP_SESS_WIDGET_CNXS	This view contains information about the sources and targets used in a session.
REP_COMPONENT	This view displays the list of tasks such as a command or an email for each session.
REP_SESS_PARTITION_DEF	This view provides partition details of the sources, targets, and transformations in a session.
REP_SESS_CONFIG_PARM	This view displays session configuration parameter details. If the session overrides a parameter in the configured object, the view displays two rows.
REP_SESS_INST_CONFIG_PARM	This view displays the attributes that are overriden at the session instance.
REP_TASK_ATTR	This view displays the attribute values and overridden values for session and workflow tasks.
REP_SESS_LOG	This view provides log information about sessions.
REP_SESS_TBL_LOG	This view contains information about the status of an individual session run against a target.

Rename Saved Search

Table of Contents

Repository Guide

Repository Guide

Workflow, Worklet, and Task Views

Workflow, Worklet, and Task Views