I have two fact tables A and B. A is about projects status and B is about project financials. They are 1 to 1 relationship. In this case, when I model the data, is it best to create a 1 to 1 relationship diagram between them or merge them as a single 1 fact table in the query editor?
Probably best to keep them separate. Only way to give you a better answer is if you could share a pbix file or something that shows all of the columns in each of the table. More than likely going to keep them they way they are.
The most likely answer to this will be to keep them separate, but have a linking table (lookup table), which just has a list of the ‘projects’
For more information on this idea. See below