I have 3 tables Customers, Accounts and Transactions. What is the best way to create a link table between them as I'm not to sure how to go about this with the load script. Hopefully this makes sense. Sample in excel was created
The specific links:
-SourcePartyType = 'C' & SourcePartyID = CustID
-DestPartyType = 'C' & DestPartyID = CustID
- However if the SourcePartyType ='A' & SourcePartyID = AcctID --> PrimaryAcctID = CustID. Same link for DestPartyType.
Sometimes a transaction can be made by a combination of the 2. Eg customer made a deposit to an acct
Any guidance would be great thanks