Which are the three types of tables available to physical tables in the physical layer?
A.
Physical Table
B.
Stored Proc
C.
Select
D.
View
E.
Table
Explanation:
Pull the table and column definition into the physical layer
Use the OBIEE import metadata wizard to pull the table and column definition into
the physical layer. The wizard is used so that all of the column definitions do not need to
be manually added into the physical layer.
Figure:Note: The physical layer is the layer of the Logical Business Model where you define the physical
data model of your data source. It contains information about the physical data sources.
ABC
In Administration Tool, right click on database name like “BISAMPLE”, choose “create new physical table” on popup menu, choose one physical table type from dropdown list “table”, “stored procedure” & “select”