Symptom
You have chosen "Remove Replicated Data" for remote tables. After the task is finished, you want to know if the replicated data are deleted or not.
Environment
SAP Datasphere
Reproducing the Issue
- Choose "Remove Replicated Data".
- Check data in "Data Viewer".
Resolution
After "Remove Replicated Data", the data replicated to local has been deleted. If you choose "Data Viewer", data is accessed directly from the source (federation) and read from the virtual table.
And in this case, "Data Access" type is "Remote".
If there are replicated data in local table, "Data Access" will be "Replicated(Real-Time)" or "Replicated(Snapshot)" depending on the data will be updated in real-time or not.
See SAP Help Document: Replicating Data and Monitoring Remote Tables
Keywords
how to check, loading, replicate, delete , KBA , DS-DI-RT , Remote Tables , How To