Data Archive
- Data Archive 6.4.3 HotFix 1
- All Products
Interim Detail Tab | Function |
---|---|
General Information | An (auto-generated) Name and (pre-specified) Description of the Interim table is displayed. |
Tables | All Tables involved in the Data Archive job executions are listed here. Tables can be added or deleted using Add and Delete. The following information is specified for each Table involved:
|
Default Columns | A number of Default Columns can be specified for the Interim tables, each accompanied with the representation of a column from a Business Table. This is specified using the values indicated below:
From Clause: FROM clause in the SQL query, specifying target Columns to be selected while building the Interim Table. Where Clause: WHERE clause to filter ROWS for Columns selected while building the Interim Table. |
Business Rules | Business rules can be specified, which occupy one column each in the interim table (as a flag which indicates its validation status). The value inserted in the “purgeable_flag” column is actually a binary summation of the values in the Columns complying to each of the Business Rules Business Rules are defined with the following information:
|
Indexes | An INDEX can be specified by clicking on Add and deleted using Delete. Order of execution of Indexes can be altered using Up Arrow and Down Arrow. These buttons are available to the right of the Details Pane. Generally, default Indexes are generated by clicking on Insert Default Index, at the bottom of the Details Pane. |
Report Statements | Statements for generating Detail Reports can be specified here. The following information is specified in order to associate a Report Statement with an Interim table:
The following information is automatically displayed on the right, when a Statement is selected.
|