Sample Header Ad - 728x90

How can we trim bad data and output clean trimmed data using DQS or MDS?

5 votes
2 answers
364 views
Until now, we have used stored procedures for data massaging and cleansing but we have now decided to move to using Data Quality Services (DQS) and Master Data Management (MDS) in our data warehouse projects. There is one very common function which we use in our stored procedures - it trims and replaces the , character with white space e.g.: UPDATE [Table] SET Column=(ltrim(rtrim(replace(Column,',','')))) I have spent hours to figure out a way to achieve this using DQS and MDM but couldn't find any way to achieve the same goal. I would really appreciate if you guys can help me out with this. In fact, thank you already for your precious time.
Asked by Ghalib Mustafa (51 rep)
Apr 30, 2019, 02:39 PM
Last activity: Jun 19, 2019, 08:20 AM