ds-blog-icon.png

THE DATA DOWNLOAD

As leaders in Enterprise Data Management and Business Intelligence, we pride ourselves on being able to deliver successfully on our projects as well as provide high-quality content to our readers.

Informatica Data Quality Standards: Tips

Posted by Sally McCormack on Apr 25, 2016 1:35:00 PM

 

CONSISTENT NAMING AND CODING STANDARDS

When designing rules in Informatica Data Quality, the developers and data stewards will see the same rules. Therefore, it is important to develop consistent naming and coding standards. For example, both the data steward and the developer will understand what “rule_” means while not everyone will understand what “mplt_” means. Therefore, mapplets should be named rule_ if they are used in both the Analyst and Developer tools.

 1_TIP_DATA_IMAGE.jpg

 

It is a best practice to include anchors and descriptions in DQ mappings for faster modifications, readability and comprehension. Any metadata changes to a source or target object in a mapping (e.g. a new column) can quickly be made if anchor transformations exist immediately following the source object and immediately preceding the target object. These

can simply be pass-through transformations. All objects should also have descriptions. The description will be displayed in the Analyst tool and can be useful to data stewards for understanding the data anomalies when viewing profiles. This can also help remind the data steward what rule was applied and whether or not it needs to be updated.

PARTNER WITH US

Do you have a current Data Quality initiative? How is your Data Quality project progressing? We’d like to hear from you. Take a few minutes to send us an email and let us know about your project. If you’d like further assistance with your current project, feel free to contact us directly. We’d be happy to talk with you and develop a proposal around your project.

 If you’d like more tips & tricks regarding Informatica Data Quality, download our eBook: SIX DESIGN TIPS IN INFORMATICA DATA QUALITY.

 

Ebook_six_design_tips_informatica_data_quality

Topics: Informatica Data Quality, Data Quality, Blog

Written by Sally McCormack