[FEATURE] Support for Technical Counter Transactions in Non-Historized Links

[molschimke]

What additional value does this feature bring to the project?

Capturing changes in source when loading data into non-historized links / satellites.

Is your feature request related to a problem? Please describe.

• https://www.youtube.com/shorts/pHA2lVS-PHU
• https://www.youtube.com/watch?v=_86LVuOIr9A

Describe the solution you'd like

Additional loading of deleted or updated rows into the non-historized link as technical counter transactions.

Describe alternatives you've considered

Workaround is to use standard links, which presents a performance issue when dealing with larger datasets (facts)

Additional context

Also required to fully support data models from Flow.BI

[marcWinkelmann]

I can support here. I built already a macro like this. Reach out to me when you start implementing it!