Salesforce Decode
Salesforcedecode
Back to questions
IntegrationIntermediatecdcsoft-deletewarehouse

Implement CDC soft delete propagation to warehouse within one-hour SLA

Real World Scenario

Salesforce Account deleted; warehouse still shows active customer 24 hours later causing duplicate marketing sends.

Expected Answer

• CDC delete events changeType DELETE propagate immediately • Warehouse merge sets deleted_at timestamp not hard remove • Subscriber processes delete within 15 minute target • Alert delete propagation lag exceeds 1 hour • getDeleted backup catch missed CDC delete events • Marketing suppression list fed from delete stream • Restore from recycle bin emits create update handle upsert

Follow-Up Questions & Answers

Click to expand — each follow-up includes a direct, interview-ready answer

Direct answer: CDC delete events changeType DELETE propagate immediately Also consider: Warehouse merge sets deleted_at timestamp not hard remove In practice: Subscriber processes delete within 15 minute target Balance speed of delivery with maintainability.

Architect Perspective

Delete SLA should match business harm—marketing duplicate justifies sub-hour delete sync.