Link is a nice exhibition of M-To-M complexities but my points of challenge - what should be my fact table the employee start date and end date are stored in the range. Will be great if i get the ideas on fact table design.

Step 1- Loop through all the employees (Between start and end date)

Step 2 -Fill fact table data daily for individual employee

Or any other trick will work;

Thanks for the help i getting in this forum

Vineet D