How to replace incorrect data

Question

Hello All:

Started enjoying the exciting features of DQS. While creating a POC on it i came across the following requirement.

Product ID should follow the syntax "PRD - <number>" (ex: PRD - 123). If source has incorrect values like 123, 0123 etc., they need to be replaced with  the correct value (i.e. PRD - 123).

Is it possible with DQS?

Answer 1

This sounds like something that SSIS would be better suited for.  DQS isn't a formatting tool.  Think of it a spell checker.

---

Phil Brammer | http://www.ssistalk.com | Twitter: http://twitter.com/PhilBrammer

Answer 2

What you could do is implement your rule in DQS and then use SSIS to read the data and pass it through the DQS component. This will flag the incorrect productIDs, so you can filter them using a conditional split and then correct them using a derived column.

---

MCTS, MCITP - Please mark posts as answered where appropriate.
Answer #1: Have you tried turning it off and on again?
Answer #2: It depends...