6.25 Key Editor

Use to create and configure keys.

A key is a set of datastore attributes that enables each datastore row to be uniquely identified. If the key is also an index, it may also allow row access to be optimized. Some drivers retrieve key descriptions during the reverse-engineering process. It is also possible to define keys directly in the repository.

The Key Editor has the following tabs:

6.25.1 Description

Properties	Description
Name	Name of the key.
Key or Index Type	Type of key or index: Primary key: A unique key, preferred for all criteria, objective (all these columns must be completed) and subjective (conciseness, performance, and so forth). Oracle Data Integrator uses the primary key as the default update key when the datastore is a mapping target. Alternate key: A unique key not used as the primary key. Not unique index: An index used to improve access performance.

Properties

Description

Name

Name of the key.

Key or Index Type

Type of key or index:

Primary key: A unique key, preferred for all criteria, objective (all these columns must be completed) and subjective (conciseness, performance, and so forth). Oracle Data Integrator uses the primary key as the default update key when the datastore is a mapping target.
Alternate key: A unique key not used as the primary key.
Not unique index: An index used to improve access performance.

6.25.2 Attributes

Use to select the attributes of the table participating in the key.

6.25.3 Control

Use to display and configure the quality control properties.

The quality control properties are taken into account during a flow control, a static control, or while loading a file.

Defined in the Database: Shows if this key has been defined in the database dictionary (or in the described application). A key that has been reverse-engineered has been defined in the database. Datastore keys are generated ONLY when Defined in the Database is selected.

Active: Shows if the key is active in the database. In some technologies, the dictionary may contain active keys (Enable) or inactive keys (Disable), that is, where the data server does not check data consistency.

Control

Shows the type of quality control for which this key is checked.

Properties	Description
Flow	During a flow control in this datastore, the key is verified if this check box is selected. This information is a default value that can be modified when the mapping is designed. It is recommended to activate this type of control to ensure data quality, even if the target technology also checks the information.
Static	During a static control, that is, during a check of the data already present in this datastore, the key is verified if the box is selected.

Synchronous Control

Properties	Description
Duplicated rows	Displays the number of duplicated rows. Click Check, to retrieve the number of records that respect or do not respect this constraint. To obtain a trace of the rows in error, a static control must be launched from either the Datastore or the Model Editor.

"Managing Security Settings" in Oracle Fusion Middleware Administering Oracle Data Integrator