29 กุมภาพันธ์ 2555 16:49
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?
3 มีนาคม 2555 1:03This 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
9 มีนาคม 2555 12:11What 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...