I'm new to the world of data modeling.
I have a relational database in DB2, which we are attempting to create a Dimensional Data Mart upon.
I have these tables in my relational database :
referral (referral_id) is joined to referral_clients(referral_client_id) on referral_id.
client_roles(client_role_id) is joined to referral_clients on referral_client_id
referral_allegation(allegation_id) is joined to client_roles on client_role_id.
All these joins are a One-to-Many from the referral table through the referral_Allegation.
If i have to denormalize these tables and create a dimensional schema, what would be the best approach?