In CMDB data manager - How does DELETE Data policy work?

Suggy
Giga Sage

In CMDB data manager - How does DELETE Data policy work? Need complete details as the docs here and here does not mention all the details

Looking for details like - when delete happens, what happens to the relationship info? what happens to the CI data that is already referenced in the tasks? What all data the csv file will contain?