Topic: How 3 facts?
All I plunge in DWH further and here ripened a question under one project...
There is a financial organization which gives credits, in system there is such concept as the Request, it is the first fact, it has the measurement with attributes, further if the request is accepted there is a Contract, it is the second fact, it too has measurements with the attributes (certainly they have the general of type the client, the worker, date etc.), goes further the table of payments, is 3 fact, a question in that as all it to connect?
The contract mandatory has a request connected to it, at the contract request can not be (refused for example and the contract is not reached), payments is traced in a source under contract number.
If to carry out in Dimensioanl the table the Contract or the Request that to the sizes it there will be as the fact though in a source both that and that are permanently updated, in particular not closed contracts (for example at them the status and some other changes).