Data Warehouse - Modeling charge document emission and it's

Pedro Soares 396 Reputation points
2022-05-04T23:44:07.96+00:00

Hi,
I was looking for the data modeling category and couldn't find it. Just wanted to brainstorm a little bit.

I am modeling a data mart where the context is issuance of a charge document and it's payments.

The charge document can be paid fully or can be fractioned in several payments. I believe these events are distinct and they need to be modeled in different fact tables, #1 - charge document issuance and #2 - charges life cycle, even though every record of fact #2 relates to a single one from #1. This almost feels like #1 should be a dimension instead of a fact.

Each record of #1 has 1...many records relantionship in #2
Each record of #2 has 1-1 record relationship in #1

Does this seem familiar to you? The issuance of the charge document is a business event I have no doubt of that, it just feels strange to connect the 2 fact tables, since each one has a star schema around each one (i'm using dimensional modeling).

Leave your thoughts please.

Cheers

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,724 questions
0 comments No comments
{count} votes