topic Fact table in QlikView

Fact table

qlikview979 — Thu, 23 Apr 2015 05:59:24 GMT

Hi experts,

what is fact table & what is the use of fact table ?

Re: Fact table

arulsettu — Thu, 23 Apr 2015 06:03:40 GMT

Fact Table contains the measureable attribute of the data.It contains measurable data that can be analyzed by Dimension tables. Fact tables contain the foreign keys of the associated Dimension tables.

in your database contain single fact table we can connect with the dimensions table to form star schema

in your database contain Multi fact table we can connect with the dimensions table to form snow flake schema

Re: Fact table

MK_QSL — Thu, 23 Apr 2015 06:04:46 GMT

Fact Tables are the Heart of Data Warehousing... They are the tables having measurements, metrics or Business process. Major work around is being done using these tables.. They should be located in center of Start Scheme (1 Fact Table only) or SnowFlake (More than 1 Fact Table))schema with Dimensions tables linked around.

Consider below case. For Sales Oriented company....

SalesTable = Fact Table

Customer Table, Supplier Table, SalesMan Table all are Dimension Table..