PowerCenter All Products
Unique identifier for the repository.
Unique identifier for the workflow.
Unique identifier for the worklet. If a session is not part of a worklet, this value is “0”.
Unique identifier for the session.
Timestamp of the Integration Service when a session starts.
Coordinated Universal Time, called Greenwich Mean Time, of when the session starts.
Repository name where sessions are stored.
Specifies the folder where the mapping and session are located.
Specifies the workflow that runs the session being logged.
Fully qualified session name that can span multiple rows. The Integration Service creates a new line for the session name. The Integration Service also creates a new line for each worklet in the qualified session name. For example, you have a session named WL1.WL2.S1. Each component of the name appears on a new line:
The Integration Service writes the line number in the LINE_NO column.
Specifies the mapping that the session uses.
Specifies the line number for each row error entry in TASK_INST_PATH that spans multiple rows.
Use the column names in bold to join tables.