i have two facts in my project .the granularity of these two facts are different. so i told my team to associate these two facts with a link table .they are telling that there are no common fields except datetime field.can any one give me the solution for this.
You don't need to combine them into a single table... may be keep two fact tables with both linked on Master calendar. Or you can concatenate the two tables into one big fact table. Link table won't make much sense if Date and Time is the only commonality between the two tables
here the two table granularity is different.so if i concatenate the granularity will be missed here.so can i make association through master calendar?.
in one fact the level of data is at customer level and the other one is at the service provides level.here over all 5 tables are there with 3 dimension tables and 2 fact tables .in these 5 tables Datetime field is common.
I don't think concatenating them would be a problem.... but I don't know your data, so difficult to say much... But you do have the option to concatenate and test vs Leave them as two tables and test
