Table of Contents

Search

  1. Preface
  2. Introduction to Enterprise Data Manager
  3. Enterprise Data Manager
  4. ILM Repository Constraints
  5. Partition Exchange Purging
  6. APIs
  7. Salesforce Accelerator
  8. SAP Application Retirement Entities
  9. Import Formats for Constraints
  10. Glossary

Enterprise Data Manager Guide

Enterprise Data Manager Guide

Interim Tables

Interim Tables

Adding an interim table to an entity is discussed in Adding and Deleting Interim Tables.
You can change the following information for the metadata as described in the following table:
Interim Detail Tab
Function
General Information
A generated name and pre-specified description of the interim table.
Tables
A list of all tables involved in the Data Archive job executions. You can add or delete tables using
Add
and
Delete
. The following information is specified for each table involved:
  • Order: INSERT, UPDATE, and DELETE statements are executed on the business tables in the order specified. You can change the order using the up arrow and down arrow.
  • Table Name.
  • Insert Statement: Generally executed while copying ROWS into Data Destination during a job execution.
  • Delete Statement: Generally executed while purging ROWS from the Data Source in a job execution.
  • Update Statements, if any.
Default Columns
You can specify default columns for the interim tables, each accompanied with the representation of a column from a business table. Use the following values:
  • Order: Order of Columns in the interim table. To promote or demote a column, use the up arrow and down arrow.
  • Name: Column name.
  • Type: Data type for records to be inserted. Generally, the data type of the business table column as specified in the SELECT clause.
  • Length: Maximum number of characters allowed, according to the specified data type.
  • PK: Use the check boxes to assign a column as a Primary Key of the interim table.
  • Select Clause: Column names from one or more business tables, whose values are fetched to populate the respective default column for the interim table.
    When an interim table is first created the columns stats_date, org_id and purgeable_flag are created by default. While stats_date and org_id can be assigned business table columns in the SELECT clause, purgeable_flag consists of a flag to determine whether the record is archivable.
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
You can specify business rules, 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 a binary summation of the values in the columns complying to each of the business rules.
Define business rules with the following information:
  • Order: Order of columns in the interim table.
  • Name: The column name in interim table which stores the validation flag for the business rule.
  • Description: A description of the business rule.
  • Business Rule Order: Order of execution of UPDATE statements on the interim table intended for applying the business rule to the data.
  • Type: Type of clause used to construct the business rule. Select from FULL, INLINE, LOOP, SET, and WHERE clauses.
  • Purge Qualification: Statement for the clause type.
  • Exclude from Evaluation: When selected, the corresponding business rule is excluded from the binary summation that determines the value in the purgeable_flag column.
  • Condition: Conditional statement that identifies the business rule.
Indexes
To specify an index, click
Add
. To delete an index, click
Delete
. To change the order of execution of indexes, use the up arrow and the down arrow 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
Specify statements for generating Detail reports.
To associate a report statement with an interim table, specify the following information:
  • Order: Order of display for columns.
  • Statement Label: A list of predefined (Reporting) statements.
  • Literals (comma separated): Specify labels for display columns.
  • Group: A column can be part of a Primary or Secondary group. This specifies the placement of columns in the Detail report of an Archive Definition.
The following information is displayed on the right, when you select a statement.
  • Parameters: You can specify parameters in the same order as they occur in the SQL query.
  • Statement: Displays the SQL query or INTERIM_VALUE, as specified during statement creation.

0 COMMENTS

We’d like to hear from you!