You can modify an object's properties from its property sheet. To open a lifecycle property sheet, double-click its Browser entry in the Lifecycles folder.
Property | Description |
---|---|
Name | Specifies the name of the item which should be clear and meaningful, and should convey the item's purpose to non-technical users. |
Code | Specifies the technical name of the item used for generating code or scripts, which may be abbreviated, and should not generally include spaces. |
Comment | Specifies a descriptive label for the item. |
Stereotype | Sub-classification used to extend the semantics of an object without changing its structure; it can be predefined or user-defined. |
Policy type | Specifies the criteria used to advance data through the lifecycle. You can choose between:
|
Start date | [age-based lifecycles only] Specifies the date from which you want the lifecycle to manage data movement. |
Total retention |
Specifies the total length of time during which data is controlled by the lifecycle. For example, if you specify a total retention of 5 years, the lifecycle will manage the movement of each record from the moment of its creation until it has existed for 5 years. For age-based lifecycles, the total retention time must be equal to the sum of all the retention times of all the phases contained within the lifecycle. For access-based lifecycles, the total retention time is used as the minimum total time that the data must remain in the lifecycle. |
Partition range | [age-based lifecycles only] Specifies the period of data to be contained in partitions for tables governed by the lifecycle. For example, a partition range of one month means that each partition will contain one month's data. |
Lists the phases (see Phases (PDM)) associated with the lifecycle. You can create phases directly on this tab.
Lists the tables subject to the lifecycle. You can add tables to the lifecycle on this tab and also specify all the properties necessary for them to participate in the lifecycle. The following tools are available on this tab:
Tool | Description |
---|---|
|
Properties - Opens the property sheet of the selected table. |
|
Analyze Cost Saving - Calculates an estimate of the cost savings to be obtained by moving the data to cheaper storage during the course of the lifecycle. |
|
Add Objects - Opens a dialog to add tables to the lifecycle. Note that if the lifecycle is used to archive data in an external database, the choice of tables to attach is limited to the tables in the external database, and the selected tables are generated to the warehouse PDM if they were not already present. |
|
Create an Object - Creates a new table and adds it to the lifecycle. |
|
Delete - Detaches the selected table from the lifecycle. |
|
Find a Row - Opens a dialog to let you search the list. |
|
Customize Columns and Filter - Opens a dialog to control the display of columns in the tab, and filter their contents. |
|
Enable/Disable Filter - Applies the specified filter. |