EncartaLabs

Informatica Data Discovery & Profiling

( Duration: 3 Days )

In Informatica Data Discovery & Profiling training course delegates will 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.

By attending Informatica Data Discovery & Profiling workshop, delegates will learn 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.

Attending a training on Informatica Data Analyst or having equivalent knowledge.

  • Data Analysts
  • Data Stewards
  • Developers

COURSE AGENDA

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
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
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
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

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top