Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
sarfaraz_sheikh
Contributor III
Contributor III

What is fact table ?

Dear ALL,

Can anybody tell me ...What is fact table ???

Sarfaraz

7 Replies
vinod2086
Creator II
Creator II

To start building our data model, we will load the fact table of our source data files

into QlikView.

A fact table is a table that contains the measurements across which we'll make the

analyses. The fact table is, at the same time, the central part of the data model.

Anonymous
Not applicable

if you will search this in google you will get best ans.

prma7799
Master III
Master III

Check below this might be help you

Re: Dimension,Fact and Link Table

Not applicable

According to Wiki.......

In data warehousing, a Fact table consists of the measurements, metrics or facts of a business process. It is located at the center of a star schema or a snowflake schema surrounded by dimension tables

Not applicable

Fact Table contains the measurable 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.

Not applicable

Hi, here's a link  that's suited to your question http://www.learnallbi.com/dimension-and-fact/

Not applicable