Specifying a Reference Object

You have to specify a reference object for a parent table and designate a column of the reference object as the key.

1. Add a source table with a parent-child relationship and create a view for Publication Service.
2. Click the Publication Options tab and specify the following options:
   1. Select Publish by Reference from the Storage Mode list.
   2. Type the table name to use for storage in the Publishing Table field. A common practice is to use the source table name prefixed by P_.
   3. Type the name of the view or a different database object to select source data from the Referred Object field.
      To select source data from a list of tables in the current user schema, click Add. To select an object from a different schema, click Add From. For example, select VIEW_PA1.

      Note: If you select a table from a different schema, ensure that the primary key in the selected table and the primary key in the source table are the same.
   4. Select a method for updating tables from the Update Mode list.
      For details about the modes, see the description about the Update Mode field in Publication Options Tab.

      

3. Save the adapter configuration.
4. Designate a column of the reference object as the key.
   You must explicitly designate a key column or substitute key column for the reference object, because a reference object has no external designation of the key column.
   1. Click the Configuration tab of Publication Service.
   2. In the tab, click the Class Reference link in the Schema panel to open the AE schema used by the adapter service.
   3. In the Classes tab, expand the reference object VIEW_PA1 in the All Classes panel and select the column you want to designate as the key.
      The configuration fields of the selected column are displayed in the Configuration panel.

      

   4. From the Configuration panel, select the Key check box.
5. Save the AE schema.