Introducing change management for lake landing replication tasks

Store changes settings are now available for lake landing replication tasks in a dedicated Store changes tab. With these new capabilities, lake landing replication functionality further bridges the gap with standard replication functionality, enabling consistent change management across replication task types.

Key features include:

• Change Table capture: Automatically store INSERT, UPDATE, and DELETE operations from the source in Change Tables on the target platform for incremental downstream processing.
• DDL handling options: Choose whether to automatically apply schema changes from the source to Change Tables or ignore DDL modifications to maintain fixed table structures.
• Configurable storage: Select whether to capture both before and after image data on updates, and customize Change Table naming conventions with configurable suffixes and header column prefixes.
• Header column management: Exclude specific system metadata columns from Change Tables to reduce storage requirements, or keep all header columns for complete audit information.
• Flexible full load behavior: Determine how existing Change Tables are handled when a full load starts—DROP and CREATE, delete old changes only, or keep all historical changes.
• Reorganized settings: Change Data Partitioning settings have moved from the General tab to the new Store changes tab for better organization and usability.

Store changes settings