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

What is a Transformation?

0 Answers   Informatica,


Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.

0 Answers   Amazon,


Write the major components of a Database Management System?

3 Answers  


where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it

0 Answers  


issues involved in modeling and building data werahouses

0 Answers  


if we have set auto differencial back up then waht is difference between 1.appen to media 2.over right the existing media

1 Answers   Indian Web Technology,


Explain normalization in one line?

0 Answers   C DAC, CDAC,


what is data set ?

1 Answers  


Write a query to retrieve for many to many relationships?

0 Answers   CGI,


Explain buffer manager?

0 Answers  


characters of DBMS A) non redundant B) data independence C) increased security D) all the above

1 Answers   Accenture, XP,


What is a driver in database?

0 Answers  


Categories