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 sqlcode -923 ?
What are the disadvantages of views in a database?
What is dialect in database?
What is OQL?
What is a database connection string?
What do you mean by cluster and non cluster index?
diff b/w inter process and in process
What are indexes in oracle?
How much does it cost to build a database?
Why do we need distributed database?
Integrity constraints means..? how many and what are they?
What is database client?
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)