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 HotFix 1
  • All Products

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

Back Next

Definition from Table Relationships

Definition from Table Relationships

Use tools to help you analyze and discover table relationships in the source database. Then, review the suggested relationships and create constraints from the suggestions.
Define constraints from table relationships if you are not familiar with the data model of the source database, or if you do not want to maintain constraints manually. You can use table relationships to help you discover primary and foreign key relationships and column uniqueness.
Complete the following tasks to define constraints from table relationships:
Step 1. Discover Table Relationships
You can discover table relationships from ERwin data models, data models in CSV files, profile results that you generated in Informatica Data Quality, or Informatica Data Quality profiles that you generate from Enterprise Data Manager.
Step 2. Import Table Relationships
After you discover table relationships, view and analyze the suggested relationships. Then, use the suggestions to create constraints for the related source metadata in the ILM repository.
You can discover relationships from any tables in the source. However, you can only create constraints for tables that exist in the ILM repository. Before you define constraints from table relationships, you must import metadata for all the tables that you want to discover relationships from.
If you retired the source database, you can discover table relationships from the Data Vault. You initiate the discovery from the metadata that you imported from the source database. You do not have to import metadata from the Data Vault.
Before you can discover table relationships using tools such as Informatica Data Quality or Informatica Data Explorer, you must first install a separate component called Informatica Profiling.
If you do not see the menu options to discover keys and relationships, view suggested table relationships, or view suggested unique columns, run the Informatica Data Archive Profiling installer that corresponds to your version of PowerCenter. For more information about installing Data Archive Profiling, see the
Data Archive Installation Guide
.
0 COMMENTS
We’d like to hear from you!