Dear Informatica Customers,

 

We are delighted to announce the next of the Webinar series - Data Domain Discovery and Enterprise Discovery on 27th June 2013 from 8 AM to 9AM (PST) .

 

Registrations for the Webinar are now open and the URL to register is:

 

https://informatica.webex.com/informatica/j.php?ED=240470207&RG=1&UID=0&RT=MiM0 (Join as Participant)

 

Alternatively,

 

 

More details are available below:

 

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Topic - Data Domain Discovery and Enterprise Discovery

 

About Data Domain Discovery

 

You need to identify and understand the meaning of critical source data so that you can take measures to work effectively on it. Data domain discovery is the process of discovering the functional meaning of data in the data sources based on the semantics of data.

 

Create a profile to perform data domain discovery and you can identify critical data characteristics within an enterprise. You can then apply further data management policies, such as data quality or data masking, to the data.

 

For example, discover product codes or descriptions to analyze which data quality standardization or parsing rules you need to apply to make the data useful and trustworthy. Another example is to find sensitive customer data, such as credit card numbers, email IDs, and phone numbers. You may then want to mask this information to protect it.

 

You can create and run a profile to perform data domain discovery in both Analyst and Developer tools. You can define a profile to perform data domain discovery based on the following rules:

  • Data rule- Finds columns with data that matches specific logic defined in the rule.
  • Column name rule- Finds columns that match column name logic defined in the rule.

 

About Enterprise Discovery

 

Enterprise discovery is the process of discovering column profile statistics, data domains, primary keys, and foreign keys in a large number of data sources. You can perform enterprise discovery across multiple connections or schemas.

 

As an enterprise data analyst, you may want to discover important data characteristics across a large number of data sources. The requirements can include identification of relational data assets, column profile runs on the discovered data assets, discovery of critical data characteristics within the enterprise, primary keys, and candidate keys. You would also want to view the foreign key relationships that exist across the data sources so that you can derive a data model based on the discovered relationships.

 

Enterprise discovery finds issues, patterns, trends, and critical data characteristics within information assets in your enterprise. You can choose both data sources that you imported into the Model repository and data sources from external relational connections. The data discovery process includes discovering column profile statistics, data domain analysis, data object structures including candidate keys, and data object relationships that include foreign keys.

 

You run enterprise discovery in the Developer tool and it performs the following tasks on each data source:

 

  • Run a column profile.
  • Discover data domains.
  • Infer primary keys.

 

After running column profiles, data domain discovery, and primary key profiles, the Developer tool runs a foreign key profile across all the data sources. After the Developer tool completes profiling and discovery tasks, it generates a consolidated results summary in both graphical and tabular formats.

 

Below are the key areas that will be covered under this topic.

 

  • Introduction to Data Domain Discovery
  • Terms and Definitions
  • Data Domain Glossary
  • Data Domains and Data Domain      Groups
  • Data Domain Rules
  • Using Data Domain Discovery
  • Introduction to Enterprise      Discovery
  • Enterprise Discovery results      visualization
  • Export of Enterprise      Discovery results to Excel
  • DDL Generation
  • Q&A

 

About the Speaker:

 

Sunil Adinarayana is a Lead Subject Matter Expert in Data Quality with over 5 years of experience in helping customers on PowerCenter and Data Quality product lines. He has conducted various enablement sessions for different teams across the globe in Data Quality 9x and mentored many Support engineers on the Data Quality product line.

-------------------------------------------------------------------------------------------------------------------------------------------------------------------

 

If you have any issues registering for the Webinar, please feel free to contact Pattabhi at praman@informatica.com and he will be glad to help.

 

InfaSupport Webinars are a monthly initiative from the Global Support Organization, where a Subject Matter expert will be presenting a webinar on a particular product.

 

Please do let us know if you have any topics of interest and we shall try to get a webinar arranged on the same.

 

Regards,

MySupport Portal Team