Improve Master Data Quality and Safety. Manage Master Data in Files and Use CoSort Field Controls.

Home » Solutions » Data Governance » Master Data Q And S

Improve Master Data Quality and Safety

» Solutions

Data Governance

CoSort Can Clean and Protect Master Data

Challenges:

Master Data is information about products, customers, store locations, and other common information. It's also the information in code and reference tables that many systems use. Stored in special tables, master data is used in the primary keys of data tables across your systems, and in defining and executing modeling, migration, and cleansing rules.

Master Data is data that is most likely to need data quality attention. Because it is key to so many systems and processes, poor quality Master Data can have a ripple effect across all your systems. Many companies therefore focus their data quality efforts here.

And, because Master Data is proprietary information for most companies, it's the information most likely to need field-level security. This may be especially true if your company plans to centralize its MDM operations.

Solutions:

The CoSort package's SortCL tool can help you scrub and standardize master data elements (field names and attributes) that you have defined in flat files. You can produce reports to identify changes and condition-based anomalies. You can also transform and reformat the master data itself, and provide new, reusable metadata for your master data in SortCL's simple syntax and repositories.

You can also use SortCL to quickly perform basic data quality tasks -- like duplicate and value-based filtering. In addition, SortCL's support for custom field-level transformation libraries allows you to exploit third-party data quality tool functions (like Melissa Data's). This means it is possible to integrate best-of-breed data cleansing functions directly into the above operations.

Because Master Data is often confidential, it may need the field-level protections that SortCL offers. At the same time you transform and scrub, you can tell SortCL to encrypt or otherwise mask master data files at risk, at the field level.

Thus, you can use CoSort's SortCL tool to accomplish several data quality, transformation and safety goals for your Master Data. SortCL can also generate a complete audit trial at the same time to help you monitor and verify these operations.

IRI, The CoSort Company