Deduplicate Bold Ideas

What Does It Do?

The OUD-DS3 best practice is for each constituent to have only one Bold Idea for each attribute value (e.g., only one Enhancing Health attribute).

This integrity check identifies duplicate Bold Ideas attributes so that they can be removed. 

How Is This Done?

This integrity check is run using two SQL Server views called [INTEGRITY_CHECKS].[dbo].[IDS.V-INTEGRITY CHECK-ATTRIBUTE-Bold Ideas Duplicates-1 Delete(DW)] and [INTEGRITY_CHECKS].[dbo].[IDS.V-INTEGRITY CHECK-ATTRIBUTE-Bold Ideas Duplicates-2 Readd(DW)] which are located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.

Those views query all Bold Idea attribute records for constituents with duplicate records. All copies of the records will be deleted because DMT cannot delete attributes with a GUID and must delete every instance of the attribute. Then, the Bold Idea attribute value will be re-added to the constituents’ record. 

Resources and References

S:\IDS\MES\SQL Scripts\DATA QUALITY\ATTRIBUTE

Snapshot GUID: BBDW.DIM_CONSTITUENT.CONSTITUENTSYSTEMID - BBDW.FACT_CONSTITUENTATTRIBUTE.ATTRIBUTEVALUE for the re-added attributes; null otherwise