How to create dimensional tables in data base and how do I know what are dimensional tables? what are the methods of loading FACT table?
Question asked by visitor
How to create dimensional tables in data base and how do I know what are dimensional tables? what are the methods of loading FACT table?
Question asked by visitor
Logically they are called Dimension & Fact tables. But physically they are tables with referential integrity relation.
Thx
SRIRAM N
Hope Everything Good
A fact table is a table in a star or snowflake schema that stores facts that measure the business, such as sales, cost of goods, or profit. Fact tables also contain foreign keys to the dimension tables. These foreign keys relate each row of data in the fact table to its corresponding dimensions and levels.
Each data warehouse includes one or more fact tables. Central to a "star" or "snowflake" schema, a fact table captures the data that measures the team's operations. Fact tables usually contain large numbers of rows, especially when they contain one or more years of history for a large team project.
A key characteristic of a fact table is that it contains numerical data (facts) that can be summarized to provide information about the history of the operation of the organization. Each fact table also includes a multipart index that contains, as foreign keys, the primary keys of related dimension tables and which contain the attributes of the fact records. Fact tables should not contain descriptive information or any data other than the numerical measurement fields and the index fields that relate the facts to corresponding entries in the dimension tables.