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



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

can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance

0 Answers  


What is the differnce between Order by and Group by

1 Answers  


List the properties of a transaction.

0 Answers  


What is the advantage of varchar2 over char?

0 Answers   ADITI,


utility used to obtain inform regarding the optimizes choice of access strategy for SQL stmts A) LOAD B) REORG C) COPY D) EXPLAIN

2 Answers   Accenture,






There are three servers are run by Oracle, MS Access and .Net. What are the procedure fetching the values of two variables from two servers among these?

0 Answers  


What are indexes in oracle?

0 Answers   CGI,


a __________ is a virtual table made up of subset of actual table

2 Answers  


Explain storage manager?

0 Answers  


What are the advantages of using database?

0 Answers  


CLI stands for?

3 Answers   IBM,


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

0 Answers   Abacus,


Categories