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
Explain partial key?
What is a reference table in database?
what are wrappers and build ups and what it's use?
How to implement database security?
What is a driver in database?
Should I store images in database?
What is ole db used for?
What do you mean by database?
What is dialect in database?
What is the difference between oracle and MS Access?
Which three commands cause a transaction to end?
What is sharded database?
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?
where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it
List some advantages of dbms.