Creating Data Quality Rule Templates in CDGC with Bulk Import Asset

Introduction:

In Cloud Data Governance and Catalog (CDGC), managing and ensuring the quality of your data is essential to building trusted data assets. One of the core functionalities within CDGC is the ability to create Data Quality (DQ) Rule Templates to assess the quality of your data in a standardized and automated way.

A Data Quality Rule Template defines the logic for assessing data quality based on predefined criteria, such as completeness, consistency, accuracy, or uniqueness. These templates can be applied across various data assets within your organization, enabling automated monitoring and reporting of data quality issues.

Import Asset Feature Overview

The Import Asset feature in CDGC allows the users to bring in external data definitions, metadata, or assets into the CDGC environment. This functionality can be extended to include the importation of pre-defined Data Quality Rule Templates. By importing these templates, organizations can streamline the process of ensuring that data assets meet certain quality standards without having to manually create each rule from scratch.

There are two ways to create the Data Quality Rule Template in CDGC.

• Using Business Rules
• Using Import Assets

Steps for Creating a Data Quality Rule Template Using Import Asset

1.To create the Data Quality Rule Template first step is to download the Template.

CDGC Service–>New–>Import Assets–>Download Import Template.

2.Select the Asset sheets like Business Term, Data Quality Rule Template and Relationship check box and Click the Download option.

Note: If there is an already existing business term that you want to link with the data rule template then, there is no need to select the business term option while downloading the template.

3.Template will be downloaded in the local system.

4.Fill the details in the Business Term sheet and highlighted in Red colour Columns are mandatory to fill the details.

5.Once the Business Term sheet is completed then fill the Data Quality Rule Template sheet. Provide Name as per the business requirements and get the technical rule reference id from rule specification URL where the business logic rule was created.

6.Fill the Relationship sheet

Source Asset should be the name of the Data Quality rule template.

Source Asset Type must be Data Quality Rule Template.

Target Asset should be the name of the Business Term.

Target Asset Type must be Business Term.

Relationship Type–>com.infa.ccgf.models.governance.asscPrimaryObjectofRuleTemplate

7.Once the template is filled then import the file in CDGC.

CDGC–>New–>Import Assets–>Import

8.Click the Import files then choose the saved template from our local. Click the Start Import option.

9.Template will process or read the file then will show the field mapping completed and will start progress the import job.

10.Once the job is completed, the Quality rule template will be created. Verify the job summary and import assets.

11.Validate the Business and Data Quality Rule Template in CDGC.

Conclusion:

Using the Import Asset feature in Cloud Data Governance and Catalog (CDGC) to create Data Quality Rule Templates streamlines the process of enforcing consistent data quality standards across your organization. It automates rule application, saving time and reducing manual effort, while ensuring reliable, accurate data for better decision-making. This approach enhances data governance, scalability, and ongoing data integrity.

Please reach out to us for your Informatica solution needs. We are an Informatica Platinum Partner with extensive experience with Informatica implementations and data integration.