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

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  

For more Databases AllOther Interview Questions Click Here
Categories