DQS Data Only Export - export only correct or corrected records

Question

Is there a way in DQS to select when exporting data only to export only correct or corrected values?

Right now for me it exports invalid values as well…

Answer 1

Short answer: Yes it's possible to export only cleaned data.

I've done that. I recollect that in the last step of the DQS project, you'll see checkboxes to select what data you want to export. I don't know what steps you're taking, if you describe that, I may be able to help:

> Can you please describe what you're trying to do?

> Also can you post the screen shot while you're on the last step of Data Quality Project?

---

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

Answer 2

Hi Paras,<o:p></o:p>

The Check-boxes you refer to are in the end of the Matching project.<o:p></o:p>

I am referring to the Cleansing project export<o:p></o:p>

Thanks!

Answer 3

Hi Eval,

No, in the DQS Client. you cannot selectively export the correct or corrected values in a Data Quality project. However, you can filter out the correct and corrected values in the exported data set if you chose the Data and Cleansing Info radio button while exporting. For example, you can use the <Domain>_Status column to know the status of the domain value after data cleansing (Suggested, New, Invalid, Corrected, or Correct).

Also, you can use the DQS Cleansing component in SSIS to selectively output the processed data based on the record or domain status of by using the Conditional Split component below the DQS Cleansing component. For more information, see this blog: Using the SSIS DQS Cleansing Component.

Thanks
Vivek
(SQL Server Documentation | Twitter: @vivek_msft)

---

NOTE: Please remember to appropriately vote a post as "helpful" or mark as "answer" to help the community.

---