Does aggregate and fact tables gets populated from
transactional data with only diffrence in there granularity?
Please clarify?
- 1 Answers
- 3193 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 |
What does specialization in DBMS mean?
Does facebook use graph database?
What is database schema name?
Re: Where can i get informatica certification Exam dumps and details? please forward it to emailid:
How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?
Explain alternate key?
Explain database partitioning.
what is meant by Dynamic query?
What is database client?
what is the difference between relational calculus and relational algebra ?
What is ole db ado?
What is ase database?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
