Building the Physical Layer of a Repository
Physical Layer - Are objects in the Physical layer, such as connection pools, folders, tables, columns, and keys
- Contains objects representing the physical data sources to which Oracle BI Server submits queries
- May contain multiple data sources
- Is typically the first layer built in a repository
 |
| Physical Layer on right side |
 |
| Physical Layer Component |
Defines relationships between tables
- Primary key
- Uniquely identifies a single row of data
- Consists of a column or set of columns
- Is identified by a key icon
- Foreign key
- Refers to the primary key columns in another table
- Is composed of a column or set of columns
 |
| Key Column |
ไม่มีความคิดเห็น:
แสดงความคิดเห็น