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 |
Explain the field term used in database.
What is sharded database?
Explain storage manager?
What are the advantages of using database?
List various types of log-based recovery in DBMS.
What is a database connection string?
wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..
What is sqlcode -923 ?
WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS?
Difference between sql and mysql?
Datatypes are unlimited,true or false?
How to do Data size testing? Who does this testing (Developer or tester)?
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)