idea Re: Compose FDW - Allow deletes from Replicate to be reflected as soft/logical deletes in DW and DM - Status changed to: Closed - Archived in Suggest an Idea

Compose FDW - Allow deletes from Replicate to be reflected as soft/logical deletes in DW and DM

QTC_Manuel — Fri, 02 Oct 2020 16:48:42 GMT

Currently Compose ignores delete records from __ct tables when processing CDC changes. It's a common use case that consumers of data from the Data Warehouse would need to know/filter on whether a record exists in the source or not. This request is to have Compose take those 'D'/DELETE operation records and give the use this to reflect this deleted state in the DW and DM.

Re: Compose FDW - Allow deletes from Replicate to be reflected as soft/logical deletes in DW and DM - Status changed to: Open - On Roadmap

Tzachi_Nissim — Wed, 28 Oct 2020 07:39:30 GMT

Hi Manuel,

Thanks for the suggestion. Handling of DELETE operations coming in from Replicate is on our roadmap. I know many users are working around this limitation using a Replicate transformation, but I agree that this needs to be part of Compose.

Regards,

Tzachi

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Mon, 18 Sep 2023 17:03:54 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: Compose FDW - Allow deletes from Replicate to be reflected as soft/logical deletes in DW and DM - Status changed to: Closed - Archived

Ideation — Mon, 18 Sep 2023 17:03:56 GMT