Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management


Metadata is data about data.

Oracle BI Suite Enterprise Edition 

You can import metadata from the source database to the repository file of Oracle BI server.  The metadata will establish the physical table information in the Physical Layer of the repository file. The following metadata can be imported:

  • Table
  • View
  • Alias
  • Synonym
  • Key
  • Foreign Key

You can import the metadata from any data source that Oracle BI server can access via ODBC or native database connection, including Excel or even a text file.