Suggest an Idea

[QTC_Manuel]

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.

[Tzachi_Nissim]

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

[Meghann_MacDonald]

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.