After importing our mapping data into DQS, the business I was working with wanted to verify that all the values were mapped/matched correctly. We had a lot of data, so scrolling thru the UI to visually test was not realistic, and we’d also need an export of the mappings.
Since there isn’t an export option thru the UI, I looked at the SQL tables. Here’s how you can replicate what I did.
First, identify which KnowledgeBase Id is used for the schema name for your target domain data.
Once you have that information, update the code below to point to the correct Knowledgebase. In my situation, the ID was 1000001.
,Parent.VALUE as MappedToTerm
,Domain.NAME as Domain
LEFTOUTER JOIN [DQS_MAIN].[KnowledgeBase1000001].[V_B_TERM] Parent
OnChild.LEADING_EXTENSION_ID = Parent.TERM_EXTENSION_ID
INNERJOIN [DQS_MAIN].[KnowledgeBase1000001].[B_DATA_SERVICE_FIELD] Domain
ONChild.FIELD_ID = Domain.ID
— Child.FIELD_ID = 1011 — Identifies the domain set, for example, Country
I hope this helps save someone time!