Bookshelf Home | Contents | Index | PDF |
Integration Platform Technologies: Siebel eBusiness Application Integration Volume ll > External Business Components > About Distributed JoinsJust as join objects can be configured in Siebel Tools and represent a 1:1 relationship between tables resident within the Siebel data model, join objects can be configured to represent a 1:1 relationship with tables external to the Siebel database. A distributed join is a 1:1 relationship between tables that spans two relational data sources. This allows a single, logical record to span multiple data sources. In using distributed joins, the join fields are read-only and the join specification can consist only of a single field. This federated field support provides the ability for the Object Manager to perform the cross-database join. Distributed joins are configured the same as standard joins. The query is distributed when the Data Source child object of the table provides a hint to the OM to federate the query. Configuring Distributed Joins and Federated FieldsTo configure distributed joins, you perform the following high-level tasks. |
Integration Platform Technologies: Siebel eBusiness Application Integration Volume ll |