Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
Can you explain the star schema for OLAP
What are fact tables and dimension tables in OLAP ?
✍: Guest
The dimensions and measures are physically represented by a star schema. Dimension tables revolve around fact table. A fact table contains a column for each measure as well as a column for each dimension. Each dimension column has a foreign-key relationship to the related dimension table, and the dimension columns taken together are the key to the fact table.
2007-10-25, 4981👍, 0💬
Popular Posts:
What is the significance of Finalize method in .NET? .NET Garbage collector does almost all clean up...
Can a variable be both const and volatile? Yes. The const modifier means that this code cannot chang...
Can you explain why your project needed XML? Remember XML was meant to exchange data between two ent...
How To Run Stored Procedures in Debug Mode? - Oracle DBA FAQ - Introduction to Oracle SQL Developer ...
How To Run a JUnit Test Class? A JUnit test class usually contains a number of test methods. You can...