topic Re: Fact & Dimension in QlikView

Fact & Dimension

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

What is the difference between fact and dimension? how come to know which one is dimension and which one is fact?

thank you.

Re: Fact & Dimension

Anil_Babu_Samineni — Wed, 22 Feb 2017 16:03:37 GMT

Try in google so that you will get lot and lot information which related. Surfing should be Fact Vs Dimensions in Data model and go to images from the under tabs

May be helps Facts vs. Dimensions: Business Intelligence

Re: Fact & Dimension

Anonymous — Wed, 22 Feb 2017 16:47:18 GMT

its tough to understand me.. please any other explaination about fact and dimension.

Re: Fact & Dimension

Anil_Babu_Samineni — Thu, 23 Feb 2017 02:36:47 GMT

Oh, May be look these images for better understand

From Above Data model, It's clear

Above another snap, Check whether which is fact as you capture very first time. Off course, Here 5 tables are single tables which associated to Fact table. And then each dimension called one Field like Ename, Sal, Deptno ....

Re: Fact & Dimension

Thu, 23 Feb 2017 07:52:56 GMT

Fact:

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.

Dimension:

Dimension Table Keys Are Connected With the Fact Table

first Load The Dimension tables then facts

Re: Fact & Dimension

Anonymous — Thu, 23 Feb 2017 10:00:15 GMT

Thank you Anil

Re: Fact & Dimension

Anonymous — Thu, 23 Feb 2017 10:04:48 GMT

Thank you kiran ,now my doubt is cleared.