Table of Contents

Search

  1. Preface
  2. Understanding the Repository
  3. Using the Repository Manager
  4. Folders
  5. Managing Object Permissions
  6. Local and Global Shortcuts
  7. Team-Based Development with Versioned Objects
  8. Labels
  9. Object Queries
  10. Team-Based Development with Deployment Groups
  11. Copying Folders and Deployment Groups
  12. Exporting and Importing Objects
  13. Exchanging Metadata
  14. Copying Objects
  15. Metadata Extensions
  16. MX Views Reference
  17. PowerCenter Reports Reference

Repository Guide

Repository Guide

Rules and Guidelines for Exchanging Metadata

Rules and Guidelines for Exchanging Metadata

Consider the following rules and guidelines when you exchange metadata with BI or data modeling tools:
  • You can export and import relational source and target definitions.
  • You can import multiple source and target definitions at a time.
  • You can export multiple source definitions or multiple target definitions at a time. You cannot export source and target definitions at the same time.
  • You cannot export cubes and dimensions. However, you can export targets to some tools as dimensions.
  • You cannot export shortcuts.
  • When you export a source or target with a foreign key, the Repository Service also exports the source or target containing the corresponding primary key.
  • When you import metadata into PowerCenter through MIMB, keys and referential integrity constraints are not persisted.
  • You must have a Metadata Exchange option license to exchange metadata for a specific tool.

0 COMMENTS

We’d like to hear from you!