Need help on Fact and Dimension Table

[#1]

Hi ,

I am new in Qlikview Develpment . Need your help to know more on Fact and Dimension Tables.

If it is possible Can any one please provide me a sample application explaning the fact tables.

Thanks!

D J

[MK_QSL]

Dimension Tables are those in which the fields and data are not changing daily or regular basis

Something like Customer Table

Here Customer Name, Customer ID, Address, Country etc

Fact Tables are those tables in which data changing regularly or daily

Something like

Sales Table

Here Invoice Number, Invoice Date, Qty, Sales Price, Total  etc

Hope this will help.

[vikasmahajan]

Fact Tables - > All Transactions tables

Dimensions ->  All Primary Key

Pfa Sample Application

Vikas

[maxgro]

fact and dimension tables are part of dimensional modeling, are not exclusive to Qlik

you can find an interesting description here

A Dimensional Modeling Manifesto - Kimball Group