Applicable for version 10.x users. Discover the content and structure of data through topics such as Data Domain Discovery and Enterprise Discovery Profiling including; Join Analysis, Functional Dependency Profiling, Primary Key Inference, Overlap Discovery and Foreign Key Profiling.
OBJECTIVES
After successfully completing this course, students should be able to:
Apply Data Domain Discovery to profiles in the Analyst Tool
Build and execute an Enterprise Discovery Profile in the Analyst Tool
Define the different types of Profiling that are available in the Developer Tool
Create and execute Enterprise Discovery Profiles in the Developer Tool
Perform Data Domain Discovery and Join Analysis Profiling
Perform Functional Dependency and Primary Key Inference
Perform Overlap Discovery and Foreign Key Profiling
Update the model with Primary and Foreign Key relationships
Generate DDL from the updated model
TARGET AUDIENCE
Data Analyst
Data Steward
Developer
PREREQUISITES
Informatica Analyst
AGENDA SUMMARY
Module 1: Analyst Tool: Data Domain Discovery and Enterprise Discovery Profiling
· Data Domain Profiling
· Inferring/identifying sensitive data
· Building and executing an Enterprise Discovery Profile
· Lab: Update a Profile to perform Data Domain Discovery
· Lab: Create, execute and review an Enterprise Discovery Profile
Module 2: Developer Tool: Advanced Profiling
· Varieties of Profiling
· Column and Enterprise Discovery Profiles
· Navigating an Enterprise Discovery Profile
· Inference Options
· Join Analysis Profiling
· Lab: Create and navigate an Enterprise Discovery Profile
· Lab: Perform Join Analysis Profiling
Module 3: Developer Tool: Functional Dependency and Primary Key Inference
· Object content and structure
· Primary Keys
· Functional Dependencies
· Sensitive Data across all objects in the model
· Lab: Import and Profile a new set of data
· Lab: Perform Functional Dependency and Primary Key Inference
Module 4: Developer Tool: Overlap Discovery and Foreign Key Profiling
· Overlap Discovery between objects
· Primary Key – Foreign Key relationships across objects
