GeekInterview.com
Series: Subject: Topic:

OLAP Interview Questions

Showing Questions 1 - 15 of 15 Questions
Sort by: 
 | 

M2m dimensions in olap cube

Asked By: Tom Haughey | Asked On: Apr 29th, 2012

We have a situation in building an olap cube where there is a m2m relationship between two dimensions. An example could be faculty and department. We have actually measures that we are collecting so there is data in the cells (not just a flag=1). In other words, we are not talking about a factless fact....

How do you implement cube security?

Asked By: babar | Asked On: Aug 22nd, 2007

Answered by: sendtorohit on: Oct 10th, 2011

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...

Multidimensional cube

Asked By: yog2005 | Asked On: Nov 19th, 2009

Explain what is multidimensional cube?

Answered by: sendtorohit on: Oct 10th, 2011

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...

Answered by: pooja11284 on: Mar 4th, 2011

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

Late arriving fact and late arriving dimension

Asked By: sudhakar568 | Asked On: Feb 16th, 2011

What is late arriving fact and late arriving dimension?

Answered by: sendtorohit on: Oct 10th, 2011

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, transparant and linked cubes

Asked By: sudhakar568 | Asked On: Feb 16th, 2011

What are replicate, transparant and linked cubes?

Answered by: sendtorohit on: Oct 10th, 2011

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...

What is the difference between olap and dss?

Asked By: suvarna | Asked On: Jun 11th, 2007

Answered by: NewtonsApple on: Jan 28th, 2010

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.

Answered by: venkatbanka on: Sep 25th, 2007

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...

What is the difference between etl tool and olap tool? What are various etl in the market? What are various olap tools? What is the future for both for next five years?

Asked By: Aditya | Asked On: Jan 21st, 2006

Answered by: tkriel on: Nov 18th, 2008

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.

Answered by: KP on: May 20th, 2006

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...

Oltp hanging application

Asked By: shanthiavari | Asked On: Jun 10th, 2008

All the users are complaining that their application is hanging. How you will resolve this situation in oltp?

Online analytical processing?

Asked By: Interview Candidate | Asked On: Aug 4th, 2005

Online analytical processing 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 summarization. Supports the data analyst in real time and enables online analysis...

Answered by: vizaik on: Mar 23rd, 2007

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.

Answered by: sithusithu on: Jan 19th, 2006

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...

What is difference between DC and adc?

Asked By: nasimakhtar | Asked On: Mar 7th, 2006

Answered by: hari on: Mar 3rd, 2007

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.

Compare data warehouse database and oltp database?

Asked By: Interview Candidate | Asked On: Aug 4th, 2005

The data warehouse and the oltp data base are both relational databases. However, the objectives of both these databases are different. The oltp database records transactions in real time and aims to automate clerical data entry processes of a business entity. Addition, modification and deletion of data...

Answered by: Ritu Khare on: Dec 15th, 2006

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

Answered by: thumatinagaraju on: Oct 23rd, 2006

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...

How to create a report with different objects can be seen at different countries not all the objects can be seen by all the countries people?

Asked By: jaspal | Asked On: May 17th, 2006

Answered by: dbaapps on: Jul 11th, 2006

Use :$flex$. in value set parameter.

What is the difference between data warehouse and online analytical processing?

Asked By: Interview Candidate | Asked On: Aug 4th, 2005

Ralph kimball the co-founder of the data warehousing concept has defined the data warehouse as a “"a copy of transaction data specifically structured for query and analysis”. Both definitions highlight specific features of the data warehouse. The former definition focuses on the structure and organization...

Answered by: sangroover on: Feb 15th, 2006

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.

Answered by: sithusithu on: Jan 10th, 2006

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...

How to enable security in cognos connection in cognos report net?

Asked By: somaraju | Asked On: Sep 13th, 2005

Answered by: kattaviz on: Sep 14th, 2005

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.

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.