When I import the metadata file (including mapping) for FDM, I find that the mapping are not replacing the existing ones, but merging instead.
Is there a way to clear all the mapping tables before importing the new metadata xml file ? Thanks.
You can log into the FDM web console, and Delete mappings for each dimension in the Activities -> Maps screen.
There is a Delete All button located on this screen. Note - this deletes by dimension.
Yes, but is there a way to empty all mapping at once? I'm importing the metadata xml file which includes mapping for all locations.
You could truncate the tdatamap table(s) in the FDM database.
You would want to test this first, but I have done so in the past in a Dev environment.
If you do a search for "Copying maps from a Test app to a Prod app directly (no excel download)", another user has posted a script that might do in part what you are looking for.