Dimensional Modeling › Data Movement Rules › Create a Data Movement Rule

Create a Data Movement Rule

You use the Data Movement Rules editor to document the data movement maintenance rules associated with the tables in your model. The Data Movement feature is available in a physical model when you select the Data Movement check box on the General tab in the Model Properties editor.

To create a data movement rule

1. Click Data Movement Rules from the Model menu.

   The Data Movement Rules dialog opens.

2. Click in an empty cell in the Rule Name column in the grid and enter a rule name.

   The rule name is added.

3. Click in the Type column of the new row and select a rule type from the list:
   • Refresh
   • Append
   • Backup
   • Recovery
   • Archiving
   • Purge

   The rule type is saved.

4. On the definition tab, enter a definition for the rule. Click Attachment to Attach the rule to one or more tables in the model.

   Click OK.

   The data movement rule is saved.