Sign Up Login


  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

how do you do sql tuning?

0 Answers   Systel,

What is ole db provider for sql server?

0 Answers  

Clipper / DBF error

1 Answers  

What is the advantage of varchar2 over char?

0 Answers   ADITI,

What is the use of default key?

0 Answers   Abacus,




hOW TO LOAD SOURCE INTO TARGET 2 TIMES?(INFORMATICA)

2 Answers  

What is a database connection string?

0 Answers  

What is a database lookup?

0 Answers  

Is hive a database?

0 Answers  

What will happen non-clustered index will be created on clustered index?

0 Answers   Abacus,

Difference between sql and mysql?

0 Answers  

What is database bounce?

0 Answers  

For more Databases AllOther Interview Questions Click Here
Categories