Single fact table by multiple fact tables using Link Table
Hi I am want to make a single fact table in my data model and i have multiple fact tables in that one to many relationship between both of the tables and i want to make a single fact using Link table by keeping the key fields in Link table and other common dimension fields as well in that. Can any one give me idea how i can achieve that whether i have to join both facts or concatenate it ?? Regards Deepak
