Wednesday, January 30, 2013 1:48 PM
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…
Wednesday, January 30, 2013 2:21 PM
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?
Wednesday, January 30, 2013 6:10 PM
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>
Friday, February 01, 2013 10:30 AM
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.
(SQL Server Documentation | Twitter: @vivek_msft)
NOTE: Please remember to appropriately vote a post as "helpful" or mark as "answer" to help the community.
- Marked As Answer by Jason H - SQLMicrosoft Employee, Moderator Monday, February 04, 2013 2:35 AM