Interested to Buy Any Domain ? << Click Here >> for more details...
Does aggregate and fact tables gets populated from
transactional data with only diffrence in there granularity?
Please clarify?
- 1 Answers
- 3608 Views
- I also Faced
- E-Mail Answers
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 |
How many types of locks are present in a database?
How heap is implemented in database?
What do you mean by database?
What is the database url?
Can you tell any two advantages of stored procedures?
what is the role of auditor in auditing data oriented applications?
What are ACID Properties?
wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..
write a query for the fifth highest salary?
17 Answers IBM, Matlabs, Ramco,
Write a query to retrieve for many to many relationships?
How default key is different from primary key?
What is the difference between primary and candidate key?
-
Oracle (3253) - 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)
