How to deal with potential duplicates as a result of the data

[eo]

Hi,

I have the following structure:

(Many) Fact > (One) Account (One) > (Many) Customer

Herewith a very simple dataset:

FACT:
FactId	AccountNumber	Balance
1	100		800
2	200		750
3	300		900
4	400		500
5	500		600

ACCOUNT:
AccountNo	AccountName
100		ABC
200		DEF
300		XYZ
400		MNO
500		JKL

CUSTOMER:
CustNo	AccountNo	CustType	Name	Surname	FullName
1111	100		NaturalPerson	Adam	Smith	Adam Smith
1112	200		NaturalPerson	Joe	Bloggs	Joe Bloggs
1113	200		NaturalPerson	Claire	Gordon	Claire Gordon
1114	300		LegalEntity	NULL	NULL	ACME
1115	400		NaturalPerson	Ben	Blair	Ben Blair
1116	500		LegalEntity	NULL	NULL	TK MAX CO

This is a mortgage solution, and you will see that Account 200 has two joint account holders, Joe Bloggs and Claire Gordon. This will cause the Fact connected to account 200 to be duplicated. How do I handle that?



EO
Hertfordshire, England