Merge using DLT

Ramu1821
New Contributor II

I have a requirement where i need only 24 hours data from my delta table

lets call this as latest table

this latest table should be in sync with source
so, it should handle all updates and inserts along with delete (if something gets deleted at source, then it should be deleted at target)

any approach for this , we are looking for a solution in context of DLT 
i am using create_auto_cdc but this is into taking care of deletes 
apply_as_deletes is only taking care of coming data, but not exisitng data