Table of Contents

Search

  1. Preface
  2. Introduction
  3. Working with Enterprise Data Manager
  4. Enterprise Data Manager
  5. ILM Repository Constraints
  6. Partition Exchange Purging
  7. APIs
  8. Smart Partitioning
  9. SAP Application Retirement Entities
  10. Import Formats for Constraints
  11. Glossary

Enterprise Data Manager Guide

Enterprise Data Manager Guide

Virtual Views

Virtual Views

A virtual view is a type of table that uses SQL logic to convert the format of retired data. You can create virtual views for any task that you can specify in the SQL.
Create virtual views to store retired data in a different format from data on the production database. For example, the date-of-birth values in a table are in integer format such as 01021991. When you retire this table to the Data Vault, the date-of-birth values remain in the same integer format. You can create a virtual view table to convert these date values to a more readable, alphanumeric format, such as 01-Feb-1991, on the retirement database.
To display the converted data, Data Archive uses the SQL created in the virtual view instead of the dynamically generated SQL used during an archive or a retirement job. You can create virtual views for data that you plan to retire. You can also create virtual views when you cannot create views on a read-only source database.
Create a virtual view to accomplish the following goals:
  • Hide the complexity of the underlying data to create a simpler user experience.
  • Save space and cost because the table is virtual.
  • Simplify the process of capturing metadata from a retirement database.

0 COMMENTS

We’d like to hear from you!