Specifying Delete Keys
The purpose of delete keys is to be able to update records in your fact
tables. For example, suppose you have a fact table called Orders. Every
day you load new orders into it. Today you loaded order number 1001 and
that order was for $100. Tomorrow the customer wants to change the order
and remove something from it -- now the value of that order is $25. Originally
the order was loaded with a value of $100 and now it needs to be updated
to be $25. With delete keys, you can re-upload the data file with that
order (1001) and the new value ($25). Doing this will replace the original
value in the fact table (by inserting all the new records and then deleting
all old records that have the same keys as the new records). In this example,
when you load the new data file, Infor
will look for any existing records where order number is equal to 1001;
if found it replaces it.
See Setting
Transaction and Snapshot Policies for a Data Source for information
about setting a transaction policy in conjunction with delete keys.
Delete keys only apply to fact tables, they do not affect dimension
tables.
To specify delete keys
|
1.
|
Go to Admin
- Define Sources - Manage Sources. |
|
3.
|
Click the
Properties tab. |
|
4.
|
Click Advanced
Options. The Advanced Properties dialog opens. |
|
5.
|
Check the
Bulk Insert and Delete Measure Records boxes. |
|
6.
|
Click Specify
Delete Keys. |
|
7.
|
In the Set
Delete Keys dialog, select the columns of the primary key of this source,
then click OK. |
|
8.
|
Click OK in
the Advanced Properties dialog. |
See Also
Setting the Primary Key
Overriding Level Keys
Setting
Transaction and Snapshot Policies for a Data Source