Re: olap

allan.parker — Fri, 13 Nov 2009 09:25:22 GMT

Hi Joe,

Fact Tables: Data in a warehouse comes from the transactions. Fact table in a data warehouse consists of facts and/or measures. The nature of data in a fact table is usually numerical. e.g. If I want to know the number of resources used for a task, my fact table will store the actual measure (of resources) while my Dimension table will store the task and resource details.

Candidate check : Binning process when creates the binned indexes, answers only some queries. The base data is not checked. The process of checking the base data is called as a candidate check. Candidate check at times may consume more time that binning process. This depends on the user query and how well it matches with the bin.

You can learn more on these topics through an E BOOK " THE MULTIDIMENSIONAL DATA MODELING TOOLKIT " available at ORACLE OLAP

Re: olap

xmldeveloper — Thu, 12 Nov 2009 15:45:49 GMT

Hi,
I am not sure what you mean by "Candidate Check".

You can get a description of a fact table using the following links:
http://en.wikipedia.org/wiki/Fact_table
http://en.wikipedia.org/wiki/Online_analytical_processing

If you need additional explanation feel free to ask.

olap

joe.valentine — Wed, 11 Nov 2009 11:43:26 GMT

hi,

what are fact tables and candidate check??

Business Intelligence - OLAP

Re: olap

Re: olap

olap