Change Data Capture
Hello,
In Azure Data Factory or Azure Synapse Analytics, it is possible to natively use CDC (Change Data Capture) enabled on a SQL Server On-prem or Azure database.
Is the same or similar functionality for incremental loading planned?
Thanks
Support UPSERTs and DELETEs when copying data into Lakehouse Tables from Pipeline copy activity, as opposed to Appending new rows
Deactivate a step in a data pipeline, without having to delete it
In a data pipeline, have you considered the possibility of deactivating a step without having to delete it?
For example, to be able to temporarily "avoid" a task without affecting the overall process.
create multiple time dimensions without duplicating tables.
The ability to create multiple time dimensions without duplicating tables.
In SSAS models, it is possible to create as many time dimensions as required by the context of the date (for example, order date). Each new date dimension inherits a key corresponding to the key of the fact table....