1 domainrule for 2 columns
-
Wednesday, January 09, 2013 2:59 PM
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?
All Replies
-
Wednesday, January 09, 2013 3:57 PM
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 )
- Proposed As Answer by Paras Doshi Thursday, January 10, 2013 6:29 PM
-
Thursday, January 10, 2013 8:22 AM
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.
