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

  1. Categories >> Software >> Databases >> Databases AllOther
  2. Suggest New Category

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

Question Posted / pratap

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

Write a query to retrieve for many to many relationships?

934

diff b/w inter process and in process

2006

WHAT IS CARDINALITIES OF JOIN?

2317

Difference between sql and mysql?

2039

What is the purpose of TNS?

981

What is table scan and index scan?

1069

What is aws documentdb?

996

What is ole db ado?

913

Which is the best graph database?

905

How do I setup a database connection?

956

A design problem was given in which I was supposed to make a design for the data base for a given problem.

1012

What is the use of default key?

1083

Is data lake a database?

917

What happens when shared and exclusive locks are applied on data item?

983

What are indexes in oracle?

1041