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 database tables and 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 elements at risk.
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.
Case Studies
White Papers
