A physical table is an object in the Physical layer of the Administration Tool that corresponds to a table in a physical database. They provide the metadata necessary for Oracle BI Server to access the tables with SQL requests. When data source definitions are imported, no actual data is moved. Data remains stored in the physical data source.
Physical Table Properties
Physical Column Property
1. Table Name: By default, the name corresponds to the table name defined during import, but you can rename it.
2. The Table Type: You can define physical table (default), store procedure and select statement. When you select either (Store procedure or select) options, a text pane below the Table Type drop-down list becomes active, allowing you to enter the stored procedure or the select statement.
3. Cacheable: Cacheable is selected by default (that means, If you enable cache in the NQconfig.INI under cache parameter, all the tables will default cache entries). You can select cache persistence time to purge cache entries.
4. Hints: Hints are instructions placed within a SQL statement that tell the database query optimizer the most efficient way to execute the statement. Hints override the optimizer’s execution plan, so you can use hints to improve performance by forcing the optimizer to use a more efficient plan.
5. Columns: A physical column is an object in the Physical layer of the Administration Tool that corresponds to a column in a physical database.
6. Keys: It’s a primary key which uniquely identifies a single row of data, it consists of a column or set of columns and is identified by a key icon.
7. Foreign Key: A foreign key is a column or a set of columns in one table that references the primary key columns in another table.
Physical Column Property
1. Table Name: By default, the name corresponds to the table name defined during import, but you can rename it.
2. The Table Type: You can define physical table (default), store procedure and select statement. When you select either (Store procedure or select) options, a text pane below the Table Type drop-down list becomes active, allowing you to enter the stored procedure or the select statement.
3. Cacheable: Cacheable is selected by default (that means, If you enable cache in the NQconfig.INI under cache parameter, all the tables will default cache entries). You can select cache persistence time to purge cache entries.
4. Hints: Hints are instructions placed within a SQL statement that tell the database query optimizer the most efficient way to execute the statement. Hints override the optimizer’s execution plan, so you can use hints to improve performance by forcing the optimizer to use a more efficient plan.
5. Columns: A physical column is an object in the Physical layer of the Administration Tool that corresponds to a column in a physical database.
6. Keys: It’s a primary key which uniquely identifies a single row of data, it consists of a column or set of columns and is identified by a key icon.
7. Foreign Key: A foreign key is a column or a set of columns in one table that references the primary key columns in another table.
Posts
