OLAP Interview Questions

The only way to access a cube (provided you are not a server admin) is through roles in the database. So you would create a role in your database, give it read permission to this cube and then add ei...

The concept of multidimensional cube is a good way to help users understand how they may want to query the multidimensional database or create OLAP reports. The dimensions of a cube are stored in a da...

A cube is a multidimensional storage model that allow many different views of data.

Late arriving Fact table: For example there was a credit card of transaction happened on 25th Mar 2005, but this record we received on 14th Aug 2007. During this period there is a possibility of chan...

Replicate Cube : A replica of the Cube is maintained across the servers as the replica.This is mainly to support high availability and efficiency. Linked Cube : A cube can be stored on a single analy...

OLAP is an element of DSS. Decision Support System is, as the name says, a SYSTEM within a business department. It is a generic term.  OLAP is a process or element of DSS which helps the analysts in DSS to arrive at a decision.

Data-driven DSS is a type of DSS that emphasizes access to and manipulation of a time-series of internal company data and sometimes external data. Simple file systems accessed by query and retrieval t...

ETL Tools Extract, Transform and Load data into a database. There are many tools on the market for ETL (Business Objects, Informatica, Data Flux, etc).

OLAP analyzes the data inthe database.

Yes, OLAP is after ETL.  Its how user's querry the data that the ETL loaded, to do analytical work; Sales Analysis for example.

OLAP Vendors: Microstrategy, BO (IE: Crystal), Hyperion...

OLAP is a concept of analyzing the data present in datawarehouse.  i.e. the data should be in denormalized form,integrated,non-volatile,time varient.  Then we can make use OLAP better.

for better decision making process and to increase the profitability of business.

A tool to evaluate and analyze the data in the data warehouse using analytical queries. A tool which helps organize data in the data warehouse using multidimensional models of data aggregation and sum...

DC: Domain Controller

ADC: Active Directory Integrated Domain Controller

In DC the zone database is stored in .dns text file where as in ADC the zone database is stored in active directory itself not in .dns file.

In simple words,

An OLTP system is used to get data into the system.

A datawarehouse system is used to get data out of the system.

-Ritu

data ware house is summarized,subject oriented,non volatile,historic, time invarient (only insertion's no updations) , denormalized. one, which support OLAP process.where as database support's detail...

Use :$flex$. in value set parameter.

OLAP--- Using the online entered data is used for analytical processing.

Data warehouse is the place where the data will pulled and kept in one place which will not change frequently and is also used for analytical processsing.

A data warehouse is a database geared towards the business intelligence requirements of an organisation. The data warehouse integrates data from the various operational systems and is typically loaded...

You can imlement security via your Windows NT system accounts, LDAP accounts for Cognos connection. To do this configure the desired Security section in the Cognos Configuration.