Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
qlikview979
Specialist
Specialist
‎2015-04-23 01:59 AM

Fact table

Hi experts,

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

197 Views
0 Likes
2 Replies
arulsettu
Master III
Master III
‎2015-04-23 02:03 AM

hi

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

127 Views
MK_QSL
MVP
MVP
‎2015-04-23 02:04 AM

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..

127 Views