What are fact tables?
A fact table is a table that contains summarized numerical and historical data (facts) and a multipart index composed of foreign keys from the primary keys of related dimension tables.
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
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 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 are late arriving Facts and late arriving dim ? How does it impacts DW? 20.09.08
Late arriving Fact table: Â Â Â Â Â Â Â This is rarely happens in practice. For example there was a credit card of HDFC transaction happened on 25...Difference between Snow flake and Star Schema. What are situations where Snow flake Schema is better than Star Schema to use and when the opposite is true? 18.09.08
Star schema contains the dimesion tables mapped around one or more fact tables. It is a denormalised model.No need to use complicated joins.Queries results fas...Differences between star and snowflake schemas ? 18.09.08
Star schema A single fact table with N number of Dimension Snowflake schema Any dimensions with extended dimensions are know as snowflake schema star schema...Give the two types of tables involved in producing a star schema and the type of data they hold. 24.01.07
Fact tables and dimension tables. A fact table contains measurements while dimension tables will contain data that will help describe the fact tables....What is “Extended Star Schema” and how did it emerge? 22.10.06
The Star Schema consists of the Dimension Tables and the Fact Table. The Master Data related tables are kept in separate tables, which has reference to the char...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...Which columns go to the fact table and which columns go the dimension table? 17.03.06
The Primary Key columns of the Tables(Entities) go to the Dimension Tables as Foreign Keys. The Primary Key columns of the Dimension Tables go to the Fact Tabl...