Monday, 12 January 2015

Defining update key for Oracle Incremental Update IKM



Define the Update Key

If you want to use update or flow control features in your interface, it is necessary to define an update key on the target datastore.

The update key identifies each record to update or check before insertion into the target. This key can be a unique key defined for the target datastore in its model, or a group of columns specified as a key for the interface.

To define the update key from a unique key:

  1. In the Target Datastore panel, select the title bar that shows the name of the target datastore to display the Property Inspector.

  2. In the Diagram Property tab, select the Update Key from the list.

Note:

Only unique keys defined in the model for this datastore appear in this list.

You can also define an update key from the columns if:

  • You don't have a unique key on your datastore. This is always the case on a temporary target datastore.

  • You want to specify the key regardless of already defined keys.

When you define an update key from the columns, you select manually individual columns to be part of the update key.

To define the update key from the columns:

  1. Unselect the update key, if it is selected. This step applies only for permanent datastores.

  2. In the Target Datastore panel, select one of the columns that is part of the update key to display the Property Inspector.

  3. In the Diagram Property tab, check the Key box. A key symbol appears in front of the column in the Target Datastore panel.

  4. Repeat the operation for each column that is part of the update key.


No comments:

Post a Comment