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

Modifying an Exported XML File

Modifying an Exported XML File

After exporting an object, you can modify the XML attributes before importing the object into a repository. For example, suppose you have inconsistent column names across a mapping. You want to globally search and replace Cust_ID and Customers_ID with Customer_ID. You can export the mapping into an XML file, modify the values in the XML file, and then import the mapping with the new values.
Modifying an XML file is an easy way to change the metadata for a repository object. However, Informatica restricts the elements and attributes you can modify in the XML file.
Use the following rules when you modify XML files:
  • Define only the metadata that you can create in the Designer or Workflow Manager. For example, do not associate a Source Qualifier transformation with a VSAM source.
  • Do not modify powrmart.dtd.
  • Verify that the structure of the XML file complies with the constraints in powrmart.dtd. For example, if powrmart.dtd says that an element must include a specified child element, make sure you include the child element.
  • You can modify the BUSINESSNAME and DESCRIPTION attributes in any element.
  • You can modify all attributes listed in Modifiable Objects, regardless of CRCVALUE codes.
  • You cannot modify attributes in an element containing a CRCVALUE unless the attribute is listed in Modifiable Objects.
  • You cannot modify attributes in an element if its parent element contains a CRCVALUE code, unless the attributes are listed in Modifiable Objects.

0 COMMENTS

We’d like to hear from you!