Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Data Archive 6.5
  • All Products

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. Salesforce Accelerator
  9. SAP Application Retirement Entities
  10. Import Formats for Constraints
  11. Glossary

Enterprise Data Manager Guide

Enterprise Data Manager Guide

Back Next

Creating a Virtual View

Creating a Virtual View

To create a virtual view, use the
Virtual View Wizard
 wizard.
  1. Go to
    View
    Constraints
    .
  2. Navigate to the application version.
  3. Right-click the application version and select
    Create Virtual View
    .
    The
    Virtual View Wizard
    wizard appears.
  4. Enter a name and a description for the virtual view that you want to create.
  5. Click
    Next
    .
    A list of the available schemas for the home database appears.
  6. Select the schemas for the virtual view, and click the down arrow.
  7. Click
    Next
    .
  8. Click the
    Add
     button to insert a blank line. Enter a name for the column, select the data type, and specify the length.
  9. Click
    Next
    .
    The
    Virtual View's SQL Text
     page appears.
  10. Enter the SQL code that the ILM Engine uses to archive the virtual view. Prefix the SQL code with the schema name so that the row count report generates correctly.
    You must provide the correct number of columns in the SQL code for the job to run successfully.
  11. Click
    Finish
    .
    The virtual view appears under the application module of the application version that you selected.
0 COMMENTS
We’d like to hear from you!