Explain a situation where multiple fact tables may be necessary

What will be an ideal response?

Multiple fact tables are useful in situations where different groups of users may need different sets of facts. One example would be a fact table to keep track of when a product is manufactured and another to keep track of when it is sold to a wholesaler. In this case, we may have two shared dimensions: date and product. These are called conformed dimensions.