使用DQS清理数据时，“值已作为校正值存在”错误

Question

在SQL Server 2012数据质量服务中，我需要按照基于术语的关系清理数据，如下所示：

字符串替换到** 沃尔玛** 沃尔玛** Wlt沃尔玛** 沃尔玛

这就是"wal“、"wlr”和"wlt“必须替换为"walmart”，最后将"walmart“替换为空空间。

它将错误显示为

SQL Server Data Quality Services
--------------------------------------------------------------------------------
2/1/2013 2:48:37 PM
Message Id: DataValueServiceTermBasedRelationCorrectedValueAlreadyCorrectingValue
Term Based Relation (walmart, ) cannot be added for domain 'keywordphrase' because 'walmart' value already exists as a correcting value.
--------------------------------------------------------------------------------
Microsoft.Ssdqs.DataValueService.Service.DataValueServiceException: Term Based Relation (walmart, ) cannot be added for domain 'keywordphrase' because 'walmart' value already exists as a correcting value.
   at Microsoft.Ssdqs.DataValueService.Managers.DomainTermBasedRelationManager.PreapareAndValidateRelation(DomainTermBasedRelation relation, IMasterContext context)
   at Microsoft.Ssdqs.DataValueService.Managers.DomainTermBasedRelationManager.Add(IMasterContext context, ServiceDefinitionBase data)
   at Microsoft.Ssdqs.DataValueService.Service.DataValueServiceConcrete.Add(IMasterContext context, ReadOnlyCollection`1 data)

任何解决方案的建议，谢谢，

Answer 1

据我了解，DQS不支持多级替换(即a->b然后b->c)。为什么不直接去空白处做第三期呢？