Oracle 1z0-591 - Oracle Business Intelligence Foundation Suite 11g Essentials

Query Limits. You can limit queries by the number of rows received, by maximum run time, and by restricting to particular time periods. You can also allow or disallow direct database requests or the Populate privilege.

See figure below.

You do not use ODBC DSN to compare repositories.

Note: When an ODBC based application connects to a database, it connects to a logical name, the Data Source Name (DSN), which identifies the datasource to which it wants to connect.

Some external repository of configuration information holds the various DSN values that are available, together with the necessary configuration and control information needed by the ODBC driver to establish a connection and manage usage of the data source.

The DSN (data source name) is a data structure that contains the information about a specific data source (database, …), typically used by an ODBC driver to be able to connect to it.

The DSN contains information about the data source such as:

the name,

the directory,

and the driver.

On Windows, the DSN also specifies the ODBC driver to be used to access the database.

Dimensional Modeling - Slowly Changing Dimensions

* Type 1 - Overwrite Original Value

A change does not require tracking

* Type 2 - Add a new record

With Type II SCD, a new version of the dimension record (row) is created, and the existing version is marked as history.

Each row does not correspond to a different instance of an entity but a different “state”, a “snapshot” of the instance at a point in time.

Note: Tracking changes in dimension is referred in datawarehousing as slowly changing dimensions.

In the source system a lot of changes are daily made :

new customers are added,

addresses are modified,

new regional hierarchies are implemented,

or simply the product descriptions and packaging change.

These sorts of changes need to be reflected in the dimension tables and in several cases, the history of the changes also needs to be tracked.

By remembering history, we are then able to look at historical data and compare it to their current situation.

CurrentDay and CurrentMonth can be calculated by a sql statement.

Note:

REPOSITORY VARIABLE(DYNAMIC)

· Initialized when BI server is started

· Assigned value dynamically based on the result of a query

· Value is dependent of the sql provided in Initialization Block

Create a dynamic variable and provide a Name and Default Initializer.Create a new initialization block by clicking on the New button in the above screen.

Provide Intialization Block variable Name

Denormalization is the process of intentionally backing away from normalization to improve performance by suppressing join and permitting the use of star transformation technique.

Denormalization should not be the first choice for improving performance and should only be used for fine tuning of a database for a particular application.

Metadata Repository Builder's Guide

http://download.oracle.com/docs/cd/E21764_01/bi.1111/e10540/toc.htm

http://download.oracle.com/docs/cd/E21764_01/bi.1111/e10540.pdf

Setting an Implicit Fact Column in the Subject Area

For each subject area in the Presentation layer, you can set an implicit fact column. The

implicit fact column is added to a query when it contains columns from two or more

dimension tables and no measures. The column is not visible in the results. It is used

to specify a default join path between dimension tables when there are several possible

alternatives or contexts.

Enterprise Install: This installation type assumes some familiarity with Oracle Business

Intelligence. All software components are downloaded onto one

computer. You can accept the default configuration settings or use

your own. You use this installation type when you have an

established Oracle WebLogic domain, and you want to extend it to

the Oracle Business Intelligence application. This install option is

typically used for more advanced deployments with multiple users,

such as to scale out a deployment on additional computers.

When you need to model many-to-many relationships between dimension tables and fact tables, you can create a bridge table that resides between the fact and the dimension tables. A bridge table stores multiple records corresponding to that dimension. In the Administration Tool, General tab in the Logical Table dialog box contains a check box that you can select to specify that a table is a bridge table.

A bridge table allows you to resolve many-to-many data relationships.

Reference; OBI Server Administration Server Guide, Version 10.1, Identifying Bridge Tables

It is asking for Which task (NOT Which Tasks).

Using Administration (not Administrator) link in OBIEE you can go to 'Manage Map Data' and manage map components.