PowerCenter
- PowerCenter 10.5
- All Products
Column Name
| Datatype
| Description
|
---|---|---|
WIDGET_INSTANCE_ID*
| NUMBER
| Instance ID of a source, target, or transformation.
|
WIDGET_TYPE
| NUMBER
| Identifies a source, target, or transformation.
|
INSTANCE_NAME
| VARCHAR2 (240)
| Instance name.
|
READER_WRITER_TYPE
| VARCHAR2 (240)
| Type of reader or writer used.
|
CNX_NAME
| VARCHAR2 (240)
| Connection name.
|
SESSION_ID*
| NUMBER
| Session ID.
|
SESSION_WIDG_INST_ID*
| NUMBER
| Transformation instance ID referenced by a session (primary key).
|
SESS_EXTN_OBJECT_TYPE
| NUMBER
| Indicates whether the object is a reader or a writer. 78 = reader; 79 = writer.
|
SESS_EXTN_OBJECT_SUBTYPE
| NUMBER
| Indicates a specific reader or writer.
|
SESS_CNX_REFS_OBJECT_TYPE
| NUMBER
| Type of referenced object.
|
SESS_CNX_REFS_OBJECT_SUBTYPE
| NUMBER
| Indicates a specific object.
|
SESS_CNX_REFS_OBJECT_ID*
| NUMBER
| ID of the referenced object.
|
WORKFLOW_ID*
| NUMBER
| Workflow ID.
|
SESSION_INSTANCE_ID*
| NUMBER
| Session instance ID.
|
SESSION_VERSION_NUMBER*
| NUMBER
| Session version number.
|
*Indicates that the column is a key column.
|