Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to link Dates in the source table to master calender

Hi,

In the fact table i have 4 date fields, like order_startdate, order_enddate, service_startdate and service_enddate,

i have created 4 separate dimension tables for these dates inorder to extract month, day and other required fields etc..

now how to link it to the fact table, please suggest me on this. Star schema is used...

1 Reply
Gysbert_Wassenaar

See this blog post: The Master Calendar


talk is cheap, supply exceeds demand