Table of Contents

Search

  1. Preface
  2. Using the Designer
  3. Working with Sources
  4. Working with Flat Files
  5. Working with Targets
  6. Mappings
  7. Mapplets
  8. Mapping Parameters and Variables
  9. Working with User-Defined Functions
  10. Using the Debugger
  11. Viewing Data Lineage
  12. Comparing Objects
  13. Managing Business Components
  14. Creating Cubes and Dimensions
  15. Using the Mapping Wizards
  16. Appendix A: Datatype Reference
  17. Appendix B: Configure the Web Browser

Designer Guide

Designer Guide

Comparing Objects Overview

Comparing Objects Overview

You can compare two repository objects of the same type to identify differences between the objects through the Designer. For example, you may want to use a target definition in a mapping, but you have two target definitions that are similar. You can compare the target definitions to see which one contains the columns you need. When you compare two objects, the Designer displays their attributes side-by-side.
You can compare the following types of objects:
  • Sources.
    You can compare two sources, two source shortcuts, or a source with a source shortcut.
  • Targets.
    You can compare two targets, two target shortcuts, or a target with a target shortcut.
  • Transformations.
    You can compare two transformations, two transformation shortcuts, or a transformation with a transformation shortcut.
  • Mappings and mapplets.
    You can compare two mappings, two mapping shortcuts, or a mapping with a mapping shortcut. You can also compare two mapplets, two mapplet shortcuts, or a mapplet with a mapplet shortcut.
  • Instances.
    Within mappings and mapplets, you can compare two source instances, two target instances, or two transformations. Within mappings, you can also compare two mapplet instances.
  • Folders.
    You can compare two folders in the Repository Manager.
  • Object shortcut versions.
    You can compare two versions of an object in the Repository Manager.
You can compare objects under the following circumstances:
  • When both objects exist in open folders.
    You can compare an object in any open folder with another object of the same type in any open folder. The folders can be in different repositories. You cannot compare objects of different types.
  • When importing an object.
    When you import an object into a folder that contains an object with the same name, the Designer lets you compare the objects to determine whether you want to overwrite or use the existing object.
  • When copying an object.
    If you copy an object into a folder that contains an object of that type with the same name, the Designer lets you compare the two objects to determine whether you want to overwrite or use the existing object.
  • When copying or deploying objects to another repository
    . If you copy or deploy an object into a folder in another repository, the Copy or Deployment Wizard compares the objects in the target folder with the objects you deploy or copy.
  • When you view an object that has multiple versions
    . You can compare the previous version of an object with the current version of the object to see the changes made to the latest version.
  • When you view an object in the Results View window
    . When you view an object in the Results View window, you can compare a previous versions of the object with the current version of the object to view the differences between the different versions.
You can compare objects across folders and repositories through the Designer. To do this, you must have both folders open. When you compare objects, a dialog box displays the results. Each dialog box contains different tabs for different types of objects.
The following figure shows a comparison of two relational sources:
The dialog box includes the General, Table, Columns, and Metadata Extensions tabs.
Each tab in this dialog box contains two columns. The left column lists the attributes in the first object you compare, and the right column lists the attributes in the second object. A divider separates the two columns. Slide the divider left or right to resize the columns. The Designer highlights differences between the objects. Ports or columns common to both objects appear in the same row.
You cannot change the metadata displayed in the results.

0 COMMENTS

We’d like to hear from you!