SSIS Data Cleansing Project in DQS

Question

On opening a Data Cleansing SSIS project in DQS client, not all the columns are visible in DQS. It only shows Domain related attributes. If all the columns were available, it would be easier to link the exported data back to source data. In absence of any linking, it is not possible to link the cleansed data back to the original data. If the cleansing project is created through DQS client, then all the attributes are available. In my scenerio, I want to clean email address for Person entity. I map email to Email domain and run cleansing through SSIS. When I open the project in DQS, only attributes available in DQS are Email related. I want tto cleanse data and then link back the corrected emails back to Invalid/error record in the data from the source so that I can programatically correct the emails and send the cleansed data to output tables.

Answer 1

I don't see a way to add all the columns as passthrough.

If you add a row id label to each row, do a Multicast, send one output to the DQS Cleansing, then one output straight through to a Merge Join, then join the rows back togethers based on their RowId.

Source --> Multicast --> DQS Cleansing --\

                              \----------------------->Merge Join on RowId--> Destinations etc

Thanks, Jason

---

Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance