Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is the difference between aggregate table and fact
table ? how do you load these two tables ?

Answer Posted / surya

Aggregate tables also known as summary tables, are fact
tables which contain data that has been summarized up to
different level(Month level, year level) of detail
aggregation.

Is This Answer Correct ?    11 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are fact, dimension, and measure?

1411


What are the different ways to represent the loading of dimension tables?

977


What are non-additive facts in detail?

1054


Explain the differences between normalizer and normalizer transformation?

1103


what is the synchonus? wht is the diff between synchronous and asynchronous what is the diff between v1 and v2 v3 delta modes in sap ecc

2540


Explain the difference between filter and conditin?

1014


Where the applications and where

964


Explain the difference between keylokup and joiner?

933


What is ods (operation data source)?

1059


Give some difference between oltp and olap.

1059


What is the difference between ods and oltp?

1078


Can we take backup when the database is opened?

1094


What is the difference between junk dimension and degenerated dimension?

1236


Explain the data type of the surrogate key?

986


What is the use of dimensional modeling in data warehousing?

1048