Explain DQS server

 Posted by Niladri.Biswas on 9/16/2012 | Category: Sql Server Interview questions | Views: 1404 | Points: 40
Answer:

The DQS server is implemented as three SQL Server catalogs that we can manage and monitor in the SQL Server Management Studio. They are

1. DQS_MAIN
2. DQS_PROJECT
3. DQS_STAGING_DATA

DQS_MAIN includes DQS stored procedures, the DQS engine, and published knowledge bases.

DQS_PROJECT includes data that is required for knowledge base management and DQS project activities.

DQS_STAGING_DATA is the staging database where the source data is dumped for performing DQS operations and then export the processed data.

The source database that contains the data to be analyzed must also be in the same SQL Server instance as the DQS server.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response