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 are the advantages of using database?
What is the purpose of firebase?
how to configure oracle 10g in java1.5 and tell me know how to set class path in system?
How does rows store in Teradata
What is database bounce?
Display the employees whose salary is less than average salary.
What is ase database?
Why do we need distributed database?
What is ole db in ssis?
Explain entity type?
write a query for the fifth highest salary?
17 Answers IBM, Matlabs, Ramco,
What is database schema name?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)