Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
See this blog post: The Master Calendar