Table of Contents

Search

  1. Preface
  2. Data integration tasks
  3. Mapping tasks
  4. Dynamic mapping tasks
  5. Synchronization tasks
  6. Data transfer tasks
  7. Replication tasks
  8. Masking tasks
  9. Masking rules
  10. PowerCenter tasks

Tasks

Tasks

Schema graph

Schema graph

A schema graph contains the graphical representation of the relationships between the multiple source objects in a
masking
task.
You can see the visual images of the multiple source objects, the relationships, and the assignments.
You can view the graph from the
Source
page or from the
Data Filters
page.
To view the object relationships on the local system, download the schema graph. The graph downloads in the following format:
<filename>.dot
The DOT language defines a graph and you can directly view the graph in the browser. If you download the DOT format file, you must use a graph visualizer tool to render, view, and manipulate graphs in the DOT language. You can download and install any open source graph visualizer tool, such as Graphviz, Canviz, Grappa, and Beluging.

Schema Graph Example

Consider that you select the following source objects in a task: Account, Case, and Contact. The parent object is Account, and the child objects are Case and Contact.
The following image shows a sample schema graph:
The Schema Graph shows the relationships between Account, Contact, and Case objects.
The path from Account to Case is the default path that the task takes after applying the filter. Then the task loads the Contact and Account parent records that are related to the Case object.
If you want to load all the contacts related to the filtered accounts and then the cases, you need to select the path from Account to Contact objects and then to the Case object. You must ensure that the subset is selected for all the objects that are included in the task. Edges marked in red indicate that the child record is selected from a parent object.

0 COMMENTS

We’d like to hear from you!