Facttable

[#1]

Hello experts im actually wondering about Facttable, i have a task from school to do, it is about circular references, synthetic keys and make a Facttable, i wonder why i should have a Facttable, or do i really need it? 

[sunilkumarqv]

Fact table where facts lies in  i.e measures

yes off course we need it to analyse the data where dimension stores the data

Dimensions and Measures

[gautik92]

you have to use joins ,applymap() to remove synthetic keys and circular references the data table with synthetic tables or circula referennces will be inconsistent

first have a look at this

What is Synthetic Keys.pdf

and have a look at attached  pdf

[krishna20]

Hi,

Some of Clear discussion over here.It may hepls

What is the difference between a fact table and a dimension table ?

Multiple fact tables, same dimensions

Dimension,Fact and Link Table

[gautik92]

This is how ur Datamodel should look like

[maxgro]

It seems to me you don't have any circular reference; your model should work as is; try to add some charts and see what it happens, problems, etc....

I think you can have some problems if you want to compare budget to sales (by year).

[#7]

Thank you, how did you do the join function? i really have to understand the logic behind this

[#8]

The synthetic key problem is now gone because i just did like that.

Itemnumber & line number was an common column

[gautik92]

rename itembranchkey as key

join itemmaster and itembranch

join state,division,region,customeraddress with customer

[avinashelite]

As maxgro‌ mentioned you don't have a circular reference in the script , try to check the data once and let us know if you face any issues