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. Appendix A: MX Views Reference
  17. Appendix B: PowerCenter Reports Reference

Repository Guide

Repository Guide

Comparing Repository Objects

Comparing Repository Objects

You can compare two repository objects of the same type to identify differences between the objects. For example, you can compare two sessions to check for differences. When you compare two objects, the Repository Manager displays their attributes.
You can compare objects across folders and repositories. To do this, you must have both the folders open. You can compare a reusable object with a non-reusable object. You can also compare different versions of the same object.
You can compare the following types of objects:
  • Designer objects.
    You can compare Designer objects, such as sources, targets, transformations, mapplets and mappings.
  • Workflow Manager objects.
    You can compare Workflow Manager objects, such as tasks, sessions, worklets, and workflows. You can compare schedulers and session configuration objects in the Repository Manager, but not in the Workflow Manager.
You can compare instances of the same type in detail. For example, if the workflows you compare contain worklet instances with the same name, you can compare the instances to see if they differ. You can compare instances of sessions and tasks in a workflow or worklet comparison. You can compare instances of mappings and transformations in a session comparison. Further, you can compare instances of the same type within a mapping or mapplet comparison.
You cannot compare objects of different types. For example, you cannot compare a source definition with a target definition.
To compare repository objects:
  1. In the Repository Manager, connect to the repository.
  2. In the Navigator, select the object you want to compare.
    To compare the first two objects in a node, select the node.
  3. Click Edit > Compare Objects.
    The Mappings dialog box appears.
  4. Click Compare.
If you choose a Designer object, a window shows the result of comparing the objects.
If you choose a Workflow Manager object, such as a session, the Diff Tool window shows the result of comparing two sessions. In the Diff Tool Window:
  • You can filter nodes that have same attribute values.
  • You can compare object instances.
  • Differences between objects are highlighted and the nodes are flagged.
  • Differences between object properties are marked.
  • The Output window displays the properties of the node you select.

0 COMMENTS

We’d like to hear from you!