Hi there,
We have interesting scenario while source source CDC changes through QLIK.
| INSERT_TS |
CUSTOMER ID |
ADDRESS ID |
SOURCE OPERATION |
|
|
|
|
| 1-Jan |
CC1 |
AA1 |
INSERT |
|
CC1 |
AA10 |
INSERT |
|
|
|
|
| 15-Jan |
CC1 |
AA1 |
BEFORE IMAGE |
|
CC1 |
AA2 |
UPDATE |
This data feeds out DV2.0, and we have LINX and LSAT for this… But as update was done on the business key itself, LINK and LSAT are presenting all three as active operation. As update to Business Key was done at source, instead of having DELETE and INSERT
| Customer_Account_LINK |
|
|
|
| LINK-HKEY |
CUSTOMER ID |
ADDRESS ID |
INSERT_TS |
|
|
|
|
| HK1 |
CC1 |
AA1 |
1-Jan |
| HK2 |
CC1 |
AA10 |
1-Jan |
| HK3 |
CC1 |
AA2 |
15-Jan |
…What’s the issue? What is the desired outcome?
Initially i thought you meant change of PK, meaning andwer is to feed new pk on “SAME AS LINK” type of construct customer_SAL table (while also loading it on the customer_HUB).
But then looked to your data and table name and .. 
:
- you table named “Customer_Account_LINK”, so it should have 2 FKs: CUSTOMER_HK and ACCOUNT_HK.
- But instead you have an attribute “ADDRESS” ? On the LINK table ?!?
A link lists transactions or facts between ontological entities either persons, companies or business concept like account, but addresses, genre, color ofveyes etc are attributes, so they belong to a SAT table (either hub sat, either link sat).
Hope this helps ~