What is the fact table?

devquora
devquora

Posted On: Feb 22, 2018

 

Fact table is the centralized table in a star schema that’s why it is also called central table. Fact table mainly contains the facts nothing measurement (values)that is related to the data in the dimension table. it typically has two types of columns one contains facts(values) and another contains foreign keys to dimension tables. a composite key that is made by all of its foreign keys is acts as a primary key of a fact table.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Informatica Interview Questions

    In warehouses how many schemas are there?

    There are four Schema’s They are: Star Schema Snow Flake Schema Galaxy Schema Fact Constellation Schema ..

    Informatica Interview Questions

    Could you explain what is Enterprise data warehouse?

    In enterprise data warehousing all organization data is created at a single point of access .data can be provided a glo..

    Informatica Interview Questions

    What is different between the data warehouse and data mart?

    A Data Mart Is a simple form of a data warehouse that is focused on a single subject or functional areas such as sales ..