Why fact table is in normal form?
I somewhat disagree venkat. There can just be SKs within a Star schema, which itself is de-Normalized. Now, if there are then FKs on the dimensions as well, I would agree.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
How can I use tables to structure forms? 01.12.08
Small forms are sometimes placed within a TD element within a table. This can be a useful for positioning a form relative to other content, but it doesn't help...What are non-additive facts ? 24.09.08
fact table typically has two types of columns: those that contain numeric facts (often called measurements), and those that are foreign keys to dimension tabl...What is Normalization, First Normal Form, Second Normal Form , Third Normal Form ? 24.09.08
Normalization : The process of decomposing tables to eliminate data redundancy is called Normalization. 1N.F:- The table should caontain scalar or atomic v...Why fact table is in normal form? 23.09.08
I somewhat disagree venkat. There can just be SKs within a Star schema, which itself is de-Normalized. Now, if there are then FKs on the dimensions as well, I...what is BUS Schema? 22.09.08
Bus Schema : Let we consider/explain these in x,y axis Dimension Table : A,B,C,D,E,F Fact Table: R,S...What is the difference between star schema and snow flake schema ?and when we use those schema’s? 20.09.08
Star Schema : Star Schema is a relational database schema for representing multimensional data. It is the simplest form of data warehouse schema that contains...what is junk dimension? what is the difference between junk dimension and degenerated dimension? 20.09.08
Junk dimension: Grouping of Random flags and text Attributes in a dimension and moving them to a separate sub dimension. Degenerate Dimension: Keeping the co...Why fact table is in normal form? 20.09.08
Basically the fact table consists of the Index keys of the dimension/ook up tables and the measures. so when ever we have the keys in a table .that itself impl...What does level of Granularity of a fact table signify? 17.03.06
Granularity The first step in designing a fact table is to determine the granularity of the fact table. By granularity, we mean the lowest level of information...What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tables? 17.03.06
Snapshot facts are semi-additive, while we maintain aggregated facts we go for semi-additive. EX: Average daily balance A fact table without numeric fact colu...