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

Does aggregate and fact tables gets populated from
transactional data with only diffrence in there granularity?
Please clarify?

Answer Posted / pratap

Th Aggregate tables will always have higher granularity than the fact table. The grain of aggregate table can be derived from one key or combination of multiple keys from within the fact table.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain partial key?

1087


What is a reference table in database?

1022


what are wrappers and build ups and what it's use?

2158


How to implement database security?

965


What is a driver in database?

1148


Should I store images in database?

1026


What is ole db used for?

1009


What do you mean by database?

1075


What is dialect in database?

971


What is the difference between oracle and MS Access?

1064


Which three commands cause a transaction to end?

1062


What is sharded database?

954


1. How to test Database? Please, give me all details for "SQL,Msaccess, Mysql Database? 2.For which functionalities database used? 3.How to convert Guest to Admin by Mysql database?

2194


where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it

2003


List some advantages of dbms.

1130