This is a Bug at Product Level and will be fixing through future hotfixes.
As a workaround,We need to add the Parameter(
DELETERELATIONSHIPS) in the generated output DataServiceQuery xml file and import the same as a ZIP file into another environment.
<CatalogInputMap Name="IM_AFF_PRODUCT_CHA_DEL" Catalog="PRODUCT">
<Name>IM_AFF_PRODUCT_CHA_DEL</Name>
<Description>Deletes association between product and characteristic</Description>
<Mergedata>true</Mergedata>
<Incremental>true</Incremental>
<ApprovalOption>D</ApprovalOption>
<SourceID/>
<CommonKey/>
<DBLoaderMode>DELETERELATIONSHIPS</DBLoaderMode> <DataSource Name="DS_AFF_RELATIONSHIP_CHA_DEL">
<PrimarySource>false</PrimarySource>
</DataSource>
After importing the updated Metadata xml the parameter is visible on UI as below.