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 / basant


Does aggregate and fact tables gets populated from transactional data with only diffrence in there ..

Answer / 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

More Databases AllOther Interview Questions

What is the difference between primary key, foreign key and candidate key?

0 Answers   Ernst Young,

How default key is different from primary key?

0 Answers   Abacus,

Explain partial key?

0 Answers  

Under which circumstance should you create an index on a table?

0 Answers   3i Infotech,

can u combine pipeline parallelism and partition parallalism? how and whan?

0 Answers   TCS,




If the master device is full, how do I make the master database bigger?

0 Answers  

what is primary key,unique key, foreign key? can u teach me in simple language?

44 Answers   Banking, CMC, CTS, HCL, Infosys, Keggfarms, SkyEss, Sunrise, TCS, Web Synergies, Wipro,

What does currency type mean in database?

0 Answers   Amazon,

What do you mean by database?

0 Answers  

What is redis good for?

0 Answers  

Is hive a database?

0 Answers  

aht is the difference b/w network & hierarchial & relational dbms????

0 Answers  

For more Databases AllOther Interview Questions Click Here
Categories