Adding relationship

Relationship tables define the relationship between two tables, based on a column that is present in both tables. Sometimes the data you extract may come from related tables. For example, you might want to define a relationship between the tables Purchase Order header and Purchase Order Line, where the Purchase Order Line table is dependent on the Purchase Order header table. The tables would be joined on the Purchase ID column common to both the tables.

A relationship is a reusable block of code and relationship tables can be used during mapping instead of having to type SQL syntax repeatedly.

Add a relationship as

  1. Click Add on the tool bar. The Add a Relationship window is displayed.
  2. Provide a name for the relationship.
  3. Specify the two tables to be related by providing the table name in the auto-suggest text boxes.
  4. Click Save.
  5. On the Relationship Columns panel, right click to add the columns on which the tables are related or alternatively click Add to add a relationship column.
  6. Click Save.

    To edit a relationship table click Edit and to remove a relationship table click Remove.

    Note: Modifying a relationship will modify it wherever it is used.