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
- 3541 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 will happen non-clustered index will be created on clustered index?
hai i want to learn oracle apps and i want to put the fake exp of one year so could you please suggest me which is best institute in hyderabad to learn oracle with real time project experience?
What is sharded database?
Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.
What is the role of driver manager?
What is the Difference Primary key and Unique Key
how can you perform lookup range in lookup stage expalin in detail?
Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.
How can we join three tables in SQL server 2000
how can we view column head in first page but not in remaining pages?
What is the importance of database partitioning?
Explain entity set?
-
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)
