Master Data Management with webMethods OneData : Working with webMethods OneData MDR : Consolidating Metadata Using Metamaps : Table Processing Mode : Fixed Columns
Fixed Columns
The following sections list the fixed columns for entities.
Fixed Columns for System/Application Master List Entity
The following table lists the fixed columns for the System/Application Master List entity.
System/Application Master List Attribute
Mandatory for Remote Load
Mandatory for File Loads
Has JDBC Property
System ID
Internally generated
ID or Name required
No
System Name
Yes
ID or Name required
No
Fixed Columns for System Tables Entity
The following table lists the fixed columns for the System Tables entity.
System Tables Attribute
Mandatory for Remote Load
Mandatory for File Loads
Has JDBC Property
Table ID
Internally generated
No
No
Table Name
Yes
Yes
Yes
Table Description
No
No
Yes
Schema Name
No
No
Yes
Type Name
No
No
Yes
Catalog Name
No
No
Yes
System ID
Yes
ID or Name required
No
Connection Name
No
No
No
Fixed Columns for System Columns Entity
The following table lists the fixed columns for the System Columns entity.
System Columns Attribute
Mandatory for Remote Load
Mandatory for File Loads
Has JDBC Property
Column Name
Yes
Yes
Yes
Column Description
No
No
No
Column Data Type
No
No
Yes
Column Length
No
No
Yes
Column Precision
No
No
Yes
Column Nullable
No
No
Yes
Column Default Value
No
No
Yes
Catalog Name
No
No
Yes
Type Name
No
No
Yes
Schema Name
No
No
Yes
Physical Order
No
No
Yes
Column ID
Internally generated
No
No
Table ID
Internally generated
No
No
System Constraint Restrictions on Import
If the source data or tables that are being imported have a primary key, foreign key, or unique constraint the following restrictions apply to the entity system constraints:
Attribute
Mandatory for Remote Load
Mandatory for File Loads
Has JDBC Property
Constraint Name
Yes
Yes
Yes
Constraint ID
Internally generated
No
No
Constraint Description
No
No
No
Constraint Column Name
Yes
No
Yes
Constraint Type ID
Yes
Yes
No
Catalog Name
No
No
Yes
Schema Name
No
No
Yes
Table Name
No
No
Yes
Table ID
Internally generated
No
No
Foreign Key Update Rule
No
No
No
Foreign Key Delete Rule
No
No
No
Is Foreign Key Deferred?
No
No
No
Is Unique?
No
No
No
IDX Qualifier
No
No
No
Sort Order
No
No
Yes
Filter Condition
No
No
Yes
Primary Key Catalog Name
No
No
No
Primary Key Schema Name
No
No
Yes
Primary Key Table Name
No
No
Yes
Primary Key Column Name
No
No
Yes
Primary Key Constraint Name
No
No
Yes
Copyright © 2011-2017 Software AG, Darmstadt, Germany. (Innovation Release)
Product LogoContact Support   |   Community   |   Feedback