Informatica Data Quality
- Informatica Data Quality 10.5.6
- All Products
Column
| Datatype
| 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 find information about the metric group to which a metric belongs.
|
METRIC_ NAME
| VARCHAR(1536)
| Metric name.
|
METRIC_WEIGHT
| NUMBER
| Weight assigned to the metric.
|
COST_TYPE
| VARCHAR(3060)
| Type of cost assigned to the metric, such as fixed cost and variable cost.
|
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 the 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.
|
RULE_NAME
| VARCHAR(3060)
| Rule name.
|
RULE_PROJECT
| VARCHAR(3060)
| Name of the project that contains the rule. The value is NULL if RULE_TYPE is EXPRESSION.
|
RULE_PATH
| VARCHAR(4000)
| Path of the rule from its root. The value is NULL if RULE_TYPE is EXPRESSION.
|
RULE_TYPE
| VARCHAR(40)
| Type of the rule, such as mapplet rule and expression rule.
|
RULE_EXPR
| CLOB
| Rule expression. The value is NULL if RULE_TYPE is MAPPLET.
|
RULE_DESC
| CLOB
| Rule description.
|