How do I configure Referential Integrity type rules in DQS?
I have a scenario where I need to validate a domain using values in another domain. Rule is : Each value in domain 1 must exist in domain 2. The list of unique values in second domain will be around 50 million. How do I do this in DQS?
You are correct in thinking that the ref integrity scenario is not directly supported in this release of DQS. However, by using a combination of existing techniques, you can get this functionality. I'll list them below. Also you may want to take a look at some of the short screencasts I've done on DQS - here.
To simulate referential integrity: 1) Create a domain from each source field in a KB 2) Create a composite domain from those source fields 3) Create a matching rule for the composite domain in your KB where the value from the first source table is the 'pivot' record is set as a prerequisite - more detail here and here.
- Is there any releavance for "ROW PER BATCH" AND "MAX INSERT COMMIT SIZE" IN SSIS PACKAGES?
- Converting varchar(6) in HHmmss format to sql time format
- Using WITH (NOLOCK) and Transactions
- Project consistency check failed. has a different ProtectionLevel than the project
- How can I delete a user from sql server 2012 who owns a schema
- Convert an existing Column to Identity
- How to get next value of SQL Server sequence in Entity Framework?
- System.Data.SqlClient.SqlException: Login failed for user
- Connection string USING Application Intent errors
- SQL Server database copy utility fails - "Login failed for user"
- Sequence as default value for a column
- Get First and Last Day of Any Year
- Recover unsaved SQL query scripts
- SQL Server stored procedure with ROW_NUMBER
- Getting total row count from OFFSET / FETCH NEXT
- Offset Fetch Next to get all rows
- No selection to install SSIS, SSRS and SSAS
- Sql Server ldf files growing very fast
- How to use Table -Valued Parameter with Dynamic query
- pymssql executemany insert value very slow
- How do I create a new user in SQL Server 2012 that I can use in a connection string?
- Replacing RAISERROR with THROW
- Cannot start LocalDB
- OLEDE Error: Login failed for user 'DOMAIN\ComputerName$'.;28000
- Why can I not find a foreign key using the OBJECT_ID() function?
- SQL Server 2012 : sa is disabled previously, due to password policy sql user is also locked
- Insert Multiple Rows Into Temp Table With SQL Server 2012
- Get total row count while paging
- Is there any way to do HTML decode in SQL Server?
- PATINDEX to detect letters and six numbers