I was not asking to do the design for me but an example. Anyway that's not a problem,  and I will find the right solution/design and how to implement it.

That's...

I agree that tracking changes on every attribute of a dimension is not always relevant that's why sometimes I am using SCD7 (a mix of type 1 and 2)

However I...

Thanks RonKyle, actually I am not confusing fact and dimension and the explanations you provided me are exactly what I understood.

However I am more confused about the ETL part and...

Thanks RonKyle! I started to read the book few days ago already (Chapter 5 already 🙂 )

In fact I read that there are 3 types of fact tables Transactional, Snapshots...

Thank you very much to all of you for your first replies.

I understand that loading the fact table with all the data every day is the easiest approach, however it...

@jeff: thank you very much for your additional explanations.
@jonathan-2: if I'm still blocked I will post the DDL with some data sample.
Thanks.

Hi Jeff,
I read both article but I' have probably miss something...

Hi Jeff,
Thank you very much for this brilliant article which brings me some light on how to deal with nodes and edges. However in my situation 2 nodes can...