I have the ff. DB table 'proposal' and 'funds' that will be transformed into a dimension (dim_proposal) and fact (fact_funds) tables. Cardinality of 'proposal' to 'funds' is zero-to-many and 'funds' to 'proposal' is one-is-to-many.
My question is should i generate fact data representing a proposal row with zero funds? In the source system, there is no generated rows for zero funded proposal. Kindly provide best approach and practices for this kind of scenario.
Thank you.