Notifications
Clear all

Modelling link from a source with no primary key  


Posts: 102
(@adarsh)
Estimable Member
Joined: 10 months ago

I am dealing with a source table which records cashflows for a agreement and unfortunately there is no PK on the table and it is valid to have records which are exactly same (entered by a batch process). The table is too long to print but I below are the important fields 

Cashflows

AgreementNr                    NOT NULL,

PostingDt                          NOT NULL,

ValueDt                            NOT NULL,

CashFlowType                  NOT NULL,

OrigCompanyCode            

Amount                            NOT NULL,

Currency                          NOT NULL

 

The one marked in bold are the HUBS in the DWH. As the structure shows there is a relation between and Agreement and Company Hubs but Company can be Null and same agreement can have multiple companycode related to it. I have modelled this table as a Multi active SAT (MSAT) to HUB_AGREEMENT but I am not sure how the LINK from this table would be modelled preserving the UoW. The options i see

1. Model the Source table as a MSAT to the LINK_AGREEMENT_COMPANY and where the companycode is null will be replaced by a default HKEY for NULLs.

2. Keep the source as an MSAT to HUB_AGREEMENT but carry the SubSequence generated to the LINK as well.

Any suggestions?

 

 

Reply
10 Replies