Data Discovery and Advanced Profiling (DDAP)(10)

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 (onDemand OR Instructor Led)
 
Show details
Agenda
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
  • Verifying and Approving relationships
  • Generating DDL to create a new schema
  • Lab: Overlap Discovery
  • Lab: Primary Key – Foreign Key relationships