Mapping Foreign Keys

This option is useful to specify the foreign key relationship. Select values for Child Table, Foreign Key, Parent Table, and Primary Key. For the child table the foreign key need not be mapped in the Mapping tab. The value of the parent gets inserted automatically.

Specifying the Sequences for Primary/Foreign Keys

Select the Mapping tab for destination node. Under Destination Cols column, select a row and click on the Sequence Name cell. A list of sequences that are available in the database is displayed. Select the sequence from the list. A message is displayed saying the column is already mapped. To change it, click Yes.

Nodes Configuration_Figure 55: Mapping Foreign Keys

1. For foreign keys, click Foreign Key Relation tab. Select the following parameters:

   Connection - Select the database Name

   Child Table - Current Table

   Foreign Key - Enter the foreign key

   Parent Table - Enter the name of the parent table

   Primary Key - Enter the primary key

2. Click Add.

   Example: For table T_OPERATION_PROPERTIES_API

   Connection - Select the database Name

   Child Table - Current Table i.e. T_OPERATION_PROPERTIES_API

   Foreign Key - OPERATION_ID

   Parent Table - T_ROUTING_OPERATIONS_API

   Primary Key - OPERATION_ID

Now O2R node is configured.