Viewing session run properties

Similar to workflow run properties, Informatica PowerCenter Workflow Monitor shows you the session-level run properties. To open the session run properties, right-click on the session and select Get Run Properties.

Viewing session run properties

The session-level run properties section will appear in the bottom-right section of the monitor screen.

Properties of task details

Task details under session run properties are shown in the following screenshot:

Properties of task details

The various options under Task Details of the session run properties are as follows:

Properties

Description

Instance Name

This indicates the name of the session.

Task Type

This indicates the type of task. In this case, it is Session.

Integration Service Name

This indicates the name of Integration Services used to run the session.

Node(s)

This indicates the nodes on which the session is running.

Start Time

This indicates the start time of the session.

End Time

This indicates the end time of the session.

Recovery Time(s)

This indicates the number of times the session has been recovered.

Status

This indicates the status of the session task.

Status Message

This indicates the status message of the session task.

Deleted

This indicates whether the session is deleted. The value can be yes or no.

Version Number

This indicates the version number of the session task.

Mapping Name

This indicates the name of the mapping associated with the session task.

Source Success Rows

This indicates the number of records that are successfully extracted using the session task.

Source Failed Rows

This indicates the number of records that failed while extracting the data using the session task.

Target Success Rows

This indicates the number of records that were successfully loaded into the target using the session task.

Target Failed Rows

This indicates the number of records that failed to load into the target using the session task.

Total Transformation Errors

This indicates the number of transformation errors that occurred during the execution of the session task.

Properties of source/target statistics

Source/Target-level task details under session run properties are shown in the following screenshot:

Properties of source/target statistics

The various options under source/target statistics of session run properties are as follows:

Properties

Description

Transformation Name

This indicates the name of the source qualifier or target instance name in the mapping.

Node

This indicates the nodes on which a particular transformation is running.

Applied Rows

This indicates the number of records that were successfully extracted from a source for processing or the records that are successfully loaded into the target after the processing.

Affected Rows

This indicates the number of records successfully extracted from the source or successfully loaded into the target.

Rejected Rows

This indicates the number of records rejected while extracting from the source or the number of records rejected while loading into the target.

Throughput(Rows/Sec)

This indicates the rate at which the data is extracted from the source or the rate at which data is loaded into the target.

Throughput(Bytes/Sec)

This indicates the rate at which the data is extracted from the source per second or the rate at which the data is loaded into the target per second.

Bytes

This indicates the total number of bytes transferred while extracting and loading the data.

Last Error Code

This indicates the latest error code that occurred while extracting or loading into the target.

Last Error Message

This indicates the latest error message that occurred while extracting or loading into the target.

Start Time

This indicates the start time of the extraction of data and the start time of the loading into the target.

End Time

This indicates the end time of the extraction of data and the end time of the loading into the target.

You can also view the partitioning- and performance-level details if you configure to get them.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset