1 domainrule for 2 columns

Question

In DQS I want make an domainrule which control is over 2 columns.

For example; when the value in column X begins with '1234' then is the value in column Y 'Water'. If not; that's an error.

An Combined Domainrule(CD) I think is not the right answer on the question. You can link the CD almost on one column.

Who has an idea how I can make this rule in DQS?

Answer 1

Yes, that is possible using composite domains.

Here's a blog post that I wrote: http://parasdoshi.com/2013/01/02/data-quality-services-composite-domains-in-action/

---

Paras Doshi (Blog: ParasDoshi.com | Twitter: @Paras_Doshi )

Answer 2

Many thanks!

My problem was that I want choose de composite domain (by he source columns) but there you must choose the normal domain and than you see step 7 that DQS signaled it by itself that he must use de composite domain.