-
What is a Star Schema
Answer posted by Chintan on 2005-05-22 18:34:55: A relational database schema organized around a central table (fact table) joined to a few smaller tables (dimension tables) using foreign key references. The fact table contains raw numeric items that represent relevant business facts (price, discount values, number of units sold, dollar value, etc.)
-
-
-
-
How can I verify the latest data from above table?
I have a table with two columns name namely current,history but I dont have time stamp to make sure that when the data is updated or deleted.
Now How can I verify the latest data from above table? -
-
-
Fact Table
Fact Table is
a) Completely Normalized
b) Partially Normalized
c) Completely De-normalized
d) Partially De-normalized
-
Entity Relationship
What relationship is resolved by an intersecting or associative entity ?
a) Recursive
b) Mandatory one to one
c) Many to Many
d) One to One
Data Warehousing Basics
Ans