Asked by:

How to edit DQS project?

Question

Once DQS project is executed once it then always opens either at stage 3 (Manage and View results) or stage 4 (Export). So far we were not able to go back to Stage 1 (Map). So how can we modify existing DQS project? What if we want to add
one more column to the process or apply a different domain to a column?

All replies

Once you finish a DQS project by clicking Finish in the
Export stage, you cannot change/modify the DQS project in terms of changing the mapping or selecting another KB to cleanse. You can only open the DQS project to review the results in the
Manage and view results stage and then Export the resultant data.

If you want to be able to change a DQS project later or to start over again, you must
not click Finish in the
Export stage. Instead after exporting the results, click
Close to just close the DQS project.

If you open SSIS projects in DQS Client, even they have the same limitation. SSIS projects open at the interactive cleansing stage (Manage View and Results tab) in DQS Client. You cannot go to the
Cleanse or Map tabs. You can only go to the
Export tab by clicking Next.

Once you finish a DQS project by clicking Finish in the
Export stage, you cannot change/modify the DQS project in terms of changing the mapping or selecting another KB to cleanse. You can only open the DQS project to review the results in the
Manage and view results stage and then Export the resultant data.

If you want to be able to change a DQS project later or to start over again, you must
not click Finish in the
Export stage. Instead after exporting the results, click
Close to just close the DQS project.

Yes, it looks like it really works like this.

However can you please explain why it was implemented this way? What kind of goal was targeted by not allowing user to modify his project later? What if user has completed series of cleanings and decided he can finish project at this point. But then 1 year
later he needs to do similar cleanings, this time with a bit different set of columns.