Informatica Data Quality
- Informatica Data Quality 10.5.6
- All Products
Column
| Description
| |
---|---|---|
PID
| NUMBER
| Serial ID of the metric that the Model Repository Service assigns.
|
NSID
| NUMBER
| Namespace ID of the metric. Each design-time object belongs to the same namespace. Each deployed object belongs to a unique namespace assigned to the deployed application.
|
METRIC _ID
| VARCHAR(3060)
| Metric ID.
|
CID
| NUMBER
| Metric container ID. A container is an object that contains other objects and child containers. For example, projects, folders, and mappings are containers.
|
METRIC_GRP_ID
| NUMBER
| Serial ID of the metric group that the Model Repository Service assigns.
You can join the METRIC_GRP_ID column with the PID column of the MRX_SC_METRIC_GROUPS view to get information on the metric group to which a metric belongs.
|
METRIC_ NAME
| VARCHAR(1536)
| Metric name.
|
METRIC_WEIGHT
| NUMBER
| Weight assigned to a metric.
|
COST_TYPE
| VARCHAR(3060)
| Type of the metric cost, such as FIXEDCOST and VARIABLECOST.
|
INVALID_ROW_COST
| BINARY_DOUBLE
| Cost associated with the metric if the COST_TYPE is FIXEDCOST. If the COST_TYPE is VARIABLECOST, the value is NULL.
|
VARIABLE_COST_FIELD
| VARCHAR(3060)
| Cost associated with the metric if COST_TYPE is VARIABLECOST. If the COST_TYPE is FIXEDCOST, the value is NULL.
|
THSLD_RANGE_FROM_VAL
| NUMBER
| Starting value of the metric threshold range.
|
THSLD_RANGE_TO_VAL
| NUMBER
| Ending value of the metric threshold range.
|
THSLD_RANGE_TYPE
| VARCHAR(24)
| Threshold range type. The value is NULL.
|
DATA_OBJ_PID
| NUMBER
| Serial ID of the data object that the Model Repository Service assigns.
|
DATA_OBJ_NSID
| NUMBER
| Namespace ID of the data object. Each design-time object belongs to the same namespace. Each deployed object belongs to a unique namespace assigned to the deployed application.
|
DATA_OBJ_ID
| VARCHAR(3060)
| Data object ID.
|
DATA_OBJ_CID
| NUMBER
| Data object container ID. A container is an object that contains other objects and child containers. For example, projects, folders, and mappings are containers.
|
DATA_OBJ_NAME
| VARCHAR(1020)
| Name of the source data object of the metric.
|
DATA_OBJ_TYPE
| VARCHAR(56)
| Type of the data object, such as relational sources, logical data objects, and flat files.
|
DATA_OBJ_PROJECT_NAME
| VARCHAR(3060)
| Name of the project that contains the data object.
|
DATA_OBJ_PATH
| VARCHAR(4000)
| Path of the data object from its root.
|