Does aggregate and fact tables gets populated from
transactional data with only diffrence in there granularity?
Please clarify?
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 |
What is a Transformation?
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.
Write the major components of a Database Management System?
where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it
issues involved in modeling and building data werahouses
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?
what is data set ?
Write a query to retrieve for many to many relationships?
Explain buffer manager?
characters of DBMS A) non redundant B) data independence C) increased security D) all the above
What is a driver in database?