Informatica Data Quality
- Informatica Data Quality 10.5.4
- All Products
Column Name
| Datatype
| Description
|
---|---|---|
STAT_ID
| VARCHAR
| ID of the statistic.
|
PARENT_STAT_ID
| VARCHAR
| ID of the parent statistic.
|
STAT_TYPE
| VARCHAR
| Type of RequestStat. The value such as MAPPINGSERVICEREQUESTSTAT, PROFILEMAPPINGREQUESTSTAT, PROFILEMODELREQUESTSTAT, PROFILERUNREQUESTSTAT, RESTREQUESTSTAT, SQLREQUESTSTAT, WSREQUESTSTAT, and MAPPINGREQUESTSTAT.
|
OBJECT_ID
| VARCHAR
| UUID of the corresponding RequestStat.
|
OBJECT_NAME
| VARCHAR
| Name of the corresponding RequestStat. For example, MappingRunStatistics may have this set to the mapping name.
|
REQUEST_TYPE
| VARCHAR
| Type of the RequestStat.
|
REQUEST_TYPE_DESC
| VARCHAR
| Description for the type of the RequestStat. The value such as 'EXECUTED-IN-DEVELOPER' if REQUEST_TYPE = 'MAPPING', 'PREVIEW-DATA-IN-DEVELOPER' if REQUEST_TYPE = 'PREVIEW', 'MAPPING-RUN-IN-APPLICATION' if REQUEST_TYPE = 'DEPLOYED_MAPPING', 'MAPPING-RUN-IN-WORKFLOW-IN-APPLICATION' if REQUEST_TYPE = NULL. For the rest of the values of REQUEST_TYPE, REQUEST_TYPE_DESC value will be same as REQUEST_TYPE.
|
LOG_ID
| VARCHAR
| Location for the workflow instance log. The value is populated when REQUEST_TYPE_DESC = 'MAPPING-RUN-IN-WORKFLOW-IN-APPLICATION'
|
LOG_FILE_NAME
| STRING
| Location for the log file of the executed RequestStat.
|
MESSAGE
| NUMBER
| Message associated with the Requeststat.
|
STATE
| VARCHAR
| State of the RequestStat. STATE_DESC column denotes description for the same.
|
STATE_DESC
| VARCHAR
| Description for the State of the RequestStat. The value such as 'RUNNING', 'COMPLETED', 'FAILED', 'ABORTED', 'TIMEOUT', 'CANCELED', 'QUEUED', 'UNKNOWN', 'RECEIVED', 'ACCEPTED', 'TBD'.
|
START_TIME
| NUMBER
| Start time of the RequestStat.
|
END_TIME
| NUMBER
| End time of the RequestStat.
|
SERVICE_NAME
| VARCHAR
| Data Integration Service Name.
|
EXECUTING_NODE_NAME
| VARCHAR
| The node that executes the job. If the request is load-balanced, then this may differ from the node where the request was initially submitted.
|
NODE_NAME
| VARCHAR
| The node that generates this statistics.
|
USER_NAME
| VARCHAR
| The User who generates this statistics.
|
SECURITY_DOMAIN
| VARCHAR
| Type of the security domain.
|
OS_PROFILENAME
| VARCHAR
| The OS Profile Name associated with a mapping.
|
EXECUTOR_TYPE
| NUMBER
| Executor type for the RequestStat. EXECUTOR_TYPE_DESC denotes description for the same.
|
EXECUTOR_TYPE_DESC
| VARCHAR
| Description for the executor type of RequestStat. The value of this column could be 'NATIVE', 'HIVE', 'CADI', 'SPARK', 'DATABRICKS', 'NONE', 'TBD'.
|
ERROR_COUNT
| NUMBER
| Error count for the RequestStat.
|
STATUS_CODE
| VARCHAR
| Status Code for the RequestStat.
|
APPLICATION_NAME
| VARCHAR
| Name of the Application associated with the RequestStat if applicable. This column is populated only in the case when STAT_TYPE column value is 'MAPPINGSERVICEREQUESTSTAT'
|
APPLICATION_ID
| VARCHAR
| ID of the Application associated with the RequestStat if applicable. This column is populated only in the case when STAT_TYPE column value is 'MAPPINGSERVICEREQUESTSTAT'.
|
CREATED_TIME
| NUMBER
| Creation time of the Application associated with the RequestStat if applicable. This column is populated only in the case when STAT_TYPE column value is 'MAPPINGSERVICEREQUESTSTAT'.
|
TX_TYPE
| VARCHAR
| Type of Transformation associated with RequestStat. Value of this column could be 'SOURCETXSTAT', 'TARGETTXSTAT'
|
TX_NAME
| VARCHAR
| Name of Transformation associated with RequestStat.
|
ROWS_PROCESSED
| NUMBER
| Number of rows successfully processed. Equivalent to the number of rows successfully read at the Source, or the number of rows successfully loaded at the target in case of SourceTx or TargetTx respectively.
|
BYTES_PROCESSED
| NUMBER
| Number of bytes successfully processed. Equivalent to number of bytes successfully read at Source or number of bytes successfully loaded at target in case of SourceTx or TargetTx respectively
|
ROWS_ERRORED
| NUMBER
| Number of rows with errors. Equivalent to number of rows successfully dropped at the Source or number of rows successfully rejected at the target in case of SourceTx or TargetTx respectively.
|
BYTES_ERRORED
| NUMBER
| Number of bytes with errors. Equivalent to number of bytes successfully dropped at the Source or number of bytes successfully rejected at the target in case of SourceTx or TargetTx respectively.
|
WORK_FLOW_JOB_ID
| VARCHAR
| Unique Stat ID of the workflow Stat associated with the RequestStat. Applicable when REQUEST_TYPE_DESC = 'MAPPING-RUN-IN-WORKFLOW-IN-APPLICATION'.
|
WORK_FLOW_NAME
| VARCHAR
| Name of a Workflow definition used to start this Stat. Applicable when REQUEST_TYPE_DESC = 'MAPPING-RUN-IN-WORKFLOW-IN-APPLICATION'.
|
WORK_FLOW_STATE
| NUMBER
| State of the workflow associated with this RequestStat; WORK_FLOW_STATE_DESC denotes description for the same.
|
WORK_FLOW_STATE_DESC
| VARCHAR
| The value of this column could be, 'RUNNING', 'COMPLETED', 'FAILED', 'ABORTED', 'TIMEOUT', 'CANCELED', 'UNKNOWN','RUNNING_RECOVERY', 'COMPLETED_RECOVERY', 'FAILED_RECOVERY', 'TBD'.
|
WORK_FLOW_START_TIME
| NUMBER
| Workflow start time.
|
WORK_FLOW_END_TIME
| NUMBER
| Workflow end time.
|