BusinessObjects Board

difference between Aggregate tables and fact tables

building semantic layer
#1

Hi ,

i want the difference between Aggregate tables and fact tables.

ne19998 (BOB member since 2008-03-20)

Tool ComparisionBusiness Objects and Micrososft SSRS
#2

A google search could have helped you. One such is found here

Jansi :india: (BOB member since 2008-05-12)

#3

Hi,

From Kimball himself :

   [url]http://www.intelligententerprise.com/030101/602warehouse1_1.jhtml[/url]

An aggregate table summarises the information from a fact table to a higher level of granualarity. It is often used for performance reasons.

Michael Abelha :australia: (BOB member since 2002-08-16)