在查詢編輯器中評估帳戶比對

使用查詢編輯器檢閱「統一帳戶」設定檔,以檢查您帳戶統一比對規則的成效。

下列查詢會比較規則集與規則集識別碼 001 的輸出,以及規則集與規則集識別碼 002 的輸出。查詢會比較每個規則集如何統一與電話號碼 555-234-5678 連結的設定檔。

若要在您組織的「查詢編輯器」中執行此查詢,請自訂您組織資料的查詢。

1. 使用對您組織有效的規則集識別碼取代指定 UnifiedLinkssotAccount 物件中的帳戶識別碼。例如,若要將規則集與識別碼 ABC 和 XYZ 進行比較,請取代 UnifiedLinkssotAccount001__dlm 和 UnifiedLinkssotAccount002__dlm 與 UnifiedLinkssotAccountABC__dlm 和 UnifiedLinkssotAccountXYZ__dlm.

2. 以您要檢閱的特定記錄的電話號碼取代範例電話號碼 (555) 234-5678。或者,使用不同的條件更新 WHERE 子句。

執行查詢後,請檢閱輸出以判斷比對規則建立的符合項目是否符合您的業務需求。若否,請微調您的比對條件和比對方法以最佳化比對。

SELECT
	"ssot__Account__dlm"."ssot__Id__c",
	"UnifiedLinkssotAccount001__dlm"."UnifiedRecordId__c" as Med_UUID,
	"UnifiedLinkssotAccount002__dlm"."UnifiedRecordId__c" as LOW_UUID,
	"ssot__Account__dlm"."ssot__Name__c",
	"ssot__ContactPointAddress__dlm"."ssot__AddressLine1__c",
	"ssot__ContactPointAddress__dlm"."ssot__AddressLine2__c",	
	"ssot__ContactPointAddress__dlm"."ssot__CityId__c",
	"ssot__ContactPointAddress__dlm"."ssot__CountryId__c",
	"ssot__PartyIdentification__dlm"."ssot__PartyIdentificationTypeId__c",
	"ssot__PartyIdentification__dlm"."ssot__Name__c" AS "Party_Name",
	"ssot__PartyIdentification__dlm"."ssot__IdentificationNumber__c",
	"ssot__ContactPointPhone__dlm"."ssot__FormattedE164PhoneNumber__c"	
FROM "ssot__Account__dlm" 
	LEFT JOIN "UnifiedLinkssotAccount001__dlm" ON "UnifiedLinkssotAccount001__dlm"."SourceRecordId__c" = "ssot__Account__dlm"."ssot__Id__c"
	LEFT JOIN "UnifiedLinkssotAccount002__dlm" ON "UnifiedLinkssotAccount002__dlm"."SourceRecordId__c" = "ssot__Account__dlm"."ssot__Id__c"
	LEFT JOIN "ssot__ContactPointAddress__dlm" ON "ssot__ContactPointAddress__dlm"."ssot__PartyId__c" = "ssot__Account__dlm"."ssot__Id__c"
	LEFT JOIN "ssot__PartyIdentification__dlm" ON "ssot__PartyIdentification__dlm"."ssot__PartyId__c" = "ssot__Account__dlm"."ssot__Id__c"
	LEFT JOIN "ssot__ContactPointPhone__dlm" ON "ssot__ContactPointPhone__dlm"."ssot__PartyId__c" = "ssot__Account__dlm"."ssot__Id__c"
WHERE "ssot__ContactPointPhone__dlm"."ssot__FormattedE164PhoneNumber__c" = '(555) 234-5678'
ORDER BY 
	"ssot__ContactPointPhone__dlm"."ssot__FormattedE164PhoneNumber__c",
	"ssot__Account__dlm"."ssot__Id__c"
LIMIT 100