-
Data Warehouse Testing Participants
Who are the participants of data warehouse testing?
-
Schema
What is the difference between snowflake and hybrid schema?
-
M2M Dimensions in OLAP Cube
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. But a Professor (Faculty) can work in many Departments and a Department can have many Faculty (Professors)....
-
How do you implement cube security?
sendtorohit
- 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
Explain What is Multidimensional Cube?
sendtorohit
- 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...
pooja11284
- Mar 4th, 2011
A cube is a multidimensional storage model that allow many different views of data.
-
Late Arriving Fact and Late Arriving Dimension
What is late arriving fact and late arriving dimension?
sendtorohit
- 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
What are replicate, transparant and linked cubes?
sendtorohit
- 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?
NewtonsApple
- 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.
venkatbanka
- 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?
tkriel
- 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.
KP
- 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
All the users are complaining that their application is hanging. How you will resolve this situation in OLTP?
-
Online Analytical Processing?
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 of data with speed and flexibility.
vizaik
- 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.
sithusithu
- 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...
-
-
Compare Data Warehouse database and OLTP database?
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 in the OLTP database is essential and the semantics of the application used in the front end impact...
Ritu Khare
- 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
thumatinagaraju
- Oct 24th, 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...
-
-
-
What is the difference between Data Warehouse and online Analytical Processing?
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 of the data and the latter focuses upon the usage of the data. However, a listing of the features...
sangroover
- 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.
sithusithu
- 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?
kattaviz
- 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.
Ans