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 |