Notifications
Clear all

Can Effectivity Satellites hold business keys/Change hash?


Posts: 17
Topic starter
(@saranyakandasamy)
Active Member
Joined: 2 years ago

We are building effectivity satellites on driving key links to say the effectivity of the relationship. This satellites holds a changehash which is computed from all the businesskey columns minus the driving key along with the operation column to identify the deletes. My question is, can effectivity sats have business keys that is used to compute the change hash. Does having the business keys in Link sats breaks the DV standard/principal?

Eg: In the below example the driving key is EmployeeID

Source:

EmployeeID  CompanyID  DateOfTransaction  Operation

101               FAF               12/01                     I

101               SAU               12/02                    U

101               FAF                12/03                    U

Link:

Link#        EmployeeHash#    CompanyHash#

#101FAF      #101                    #FAF

#101SAU     #101                    #SAU

 

Effectivity Satellite:

Link#        EmployeeID      CompanyID     Date      Operation    ChangeHash

#101FAF      101            FAF                 12/01      I                  #FAF+I

#101FAF      101            FAF                 12/01      D                  #FAF+D

#101SAU      101           SAU                12/02      U                  #SAU+U

#101SAU      101           SAU                12/03      D                 #SAU+D

#101FAF      101            FAF                 12/03      U                  #FAF+U

Reply
4 Replies