SQL ServeR语言 使用 DQS 清理数据时出现"Value already exists as a correcting value"错误

Question

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

字符串替换**

沃尔玛**

沃尔玛**

沃尔玛**

沃尔玛

那就是单词"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）。 为什么不直接进入前三个学期的空白？