| 1. |
What Are (primaries) Primary Foreign Keys? What Is The Use Of Primaries (primary Foreign Keys) In Siebel Data Model? |
|
Answer» The Siebel Data Model USES primary FOREIGN keys (or primaries) to point from a parent base table to a child base table. Primaries enable business logic in the Siebel Data Model, such as identifying the primary position for an account. Moreover, primaries improve performance by eliminating repeating sub queries when data from both the parent table and the primary child table are DISPLAYED. If you do not use primaries, then you must execute a new query to identify any child records each time a parent RECORD is displayed. The Siebel Data Model uses primary foreign keys (or primaries) to point from a parent base table to a child base table. Primaries enable business logic in the Siebel Data Model, such as identifying the primary position for an account. Moreover, primaries improve performance by eliminating repeating sub queries when data from both the parent table and the primary child table are displayed. If you do not use primaries, then you must execute a new query to identify any child records each time a parent record is displayed. |
|