transaction table vs dimension table

[abhaysingh]

hello every one

     I am little bit confuse in transaction table and dimension table.

I know basic difference but when I am preparing model its not easy for me to find the transaction table .

please help me out

[giakoum]

transactions table is where you fact data resides, like sales value for example. It also holds dimensionsIDs, that point to the dimensions tables like Product, Salesman etc.

Please refer to the attached document or the manual for more info.

[gopalopsharma]

Hello Abhay,

Qlikview follows dimensional data modeling which means a Central table will be connected with several side tables on a single key.

The Central table is known as fact table and the side table is Dimension table.

The Fact table has the details of the transactions (eg Units, Dollar values) and the IDs (e.g. Cust_ID, Store_ID etc).

These IDs are actually joined with the respective dimension table (e.g Dim_Cust, Dim_Store).

The Dimension table has several attributes of the respective ID (e.g Dim_Cust will have Cust_Name, Address, Zip, City, Contact, MailID etc)

Few requirements:

1. Fact should be unique at the columns present in it

2. Dimension should have all the IDs present in the Fact else we wont get details for those IDs

The above things can be checked after loading the data in Qlikview and then going to Table Viewer (CTRL+t) and hovering the cursor over the table and different field names (Subset Ratio, Variable Density)..

Hope this helps.