This one took me a while but I finally figured it out. I had set up my DQS knowledge base and was mapping my columns to domains in the DQS component. But I couldn’t find the domain that corresponded to a column called “Category of Disability” and that had the same name. It was not being listed. Here’s the domain:
and here the domain is not:
I thought I had not published my latest KB changes but I had. Is there a bug in the component? I could not find any complaints in the Internet. Perhaps I was the first to encounter this. Then it occurred to me that it could have to do with data types. And that was it! My column was of type varchar
but the domain was of type integer:
Once I converted the column in the query the domain “showed up” for selection in my column mapping… but, of course, only after I refreshed the metadata in my data source component:
Oh well, another happy ending.
