Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Fact table where facts lies in i.e measures
yes off course we need it to analyse the data where dimension stores the data
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
and have a look at attached pdf
Hi,
Some of Clear discussion over here.It may hepls
What is the difference between a fact table and a dimension table ?
This is how ur Datamodel should look like
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).
Thank you, how did you do the join function? i really have to understand the logic behind this
The synthetic key problem is now gone because i just did like that.
Itemnumber & line number was an common column
rename itembranchkey as key
join itemmaster and itembranch
join state,division,region,customeraddress with customer
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