Nodes in Schema Design Editor
The root node includes the following:
• All Fields - Displays all the fields across all record types.
• All Record Rules - Expands to display record rule sets, which contain record recognition rules.
– Recognition Rule Sets - Displays the list of recognition rules for a Hierarchical connector.
– Recognition Rules - Displays recognition rules for the named rule set.
– Record discriminators are set at the group (for hierarchical schema) or schema (for flat file schema) level.
• All Record Types - Displays all the types of records.
• All Record Instances - Displays all instance records. Instance records are full paths to records. Hierarchical schema are built by having fields in a parent record type reference a different record type. For example, an invoice record may contain a ShipTo field that references an Address record type and a BillTo field that also references an Address record type. In this case, there are two record types (Invoice and Address), but three record instances (Invoice, Invoice/ShipTo, and Invoice/BillTo). Instances are important when mapping fields between sources and targets because the ShipTo location may be different from the BillTo location even if they are both Address type records.
– Record Nodes (example, ShipTo:Address)
• Groups
• Recognition Rules - Displays recognition rule for the selected record.
Note:
Recognition Rules node is displayed based on the selected connector. Also, this node is not applicable for certain connectors.
Validation Rules node is not displayed for JSON schema.
Recognition Rule Sets is displayed only for JSON Schema with Hierarchical connector.
Events are not included.
Schema is always unlocked and editable.
The following image shows the source and target tree views for JSON schema with a few sample connectors.
Last modified date: 10/22/2024