- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Tuesday
Hi,
I'm using create_auto_cdc_flow, scd type 2. In source I have a metadata which tells the origin of the row. This column should not trigger new version row, so it is added to track_history_except_column_list.
I don't want to add it to exception column list, because once a new version of row is created I would like this value to be added together with new version of the row.
However there is an unwanted behavior, if this value is changed, and other values not (now new row created) then in target latest version of the row this value being updated to the value from source, but I would like this value in target to stay as it is and only be added if new version of row is created.
Does anybody knows how to achieve this goal?