Data Integration with Informatica

3 Day Classroom  •  3 Day Live Online
3 Day Training at your location.
Adjustable to meet your needs.
When training eight or more people, onsite team training offers a more affordable and convenient option.
Register Now
Request Quote

This course gives you practical, immediately useful skills on the Informatica family of enterprise data integration products. You will learn to power your organization's data engineering and analytics strategies by using Informatica to access and integrate data from any business system, in any format, and deliver that data throughout the enterprise. 

On today's enterprise teams, understanding how to intelligently manage and leverage the vast amounts of data your organization uses in a way that provides holistic, strategic business value is a must. By the end of this class, you will understand how to use Informatica data integration products and how they enable a coherent strategy for managing, preparing and integrating data throughout the enterprise.

Use Informatica for Data ETL (Extract/Transform/Load)
Navigate the requirements and architecture associated with Informatica for data projects and functions
Use the various products in the Informatica suite for a full range of data engineering needs
Build models, projects, objects and profiles
Generate scorecards for data quality
Use Informatica for complex data transformations
Enact data flow rules, workflows, schedules, variables and parameters
Perform complex work with metadata
Use Powerexchange for powerful interoperability with many types of data
Upcoming Dates and Locations
Guaranteed To Run

There aren’t any public sessions currently scheduled for this course, but if you fill out the form below, we can tell you about how we can bring this course to you!

Course Outline

Part 1: Introduction to Extract, Transform, Load (ETL)

  1. Extract
    • What does it mean?
    • How do I identify my sources?
  2. Transform
    • Identify common issues
    • Understand Master Data Management and quality control within the integration process
    • Utilizing transform phase to address common problems
  3. Load
    • What does it mean?
    • How do I identify my targets?

Activity: Students will be presented with a business scenario and will need to identify the sources the data should be extracted from, what types of transformations might be useful to maintain data quality and finally where the data should move to post-transformation.

Part 2: Introduction to Informatica Product Suite

  1. Identify data integration requirements
    • Informatica value proposition
    • Why use Informatica?
  2. Data Integration Architecture
    • Explore the Informatica architecture
    • Informatica use cases
  3. Introducing the Informatica Data Integration Products
    • Data Explorer
    • Data Validation
    • Metadata Manager
    • PowerCenter
    • PowerExchange

Activity: Students will be placed in groups and given a scenario and should create a use case diagram that identifies which tools should be utilized to solve data problems across the business process.  They should be identifying the correct tool at the correct time in the process.

Part 3: Introduction to Informatica Developer

  1. Using the Informatica Analyst tool
    • Creating project
    • Profiling data
    • Create rules in profiles
    • Score Data
    • Manage Data quality issues
    • Creating reference tables from profile results

Activity: Students will create a new project that will be used to profile a sample data set provided for this activity.  They will experiment with profile rules, data scoring, and reference table management.

Part 4: Introduction to PowerCenter

  1. Building mappings to extract data from sources
    • Building sources with PowerCenter
    • Exploring the Source Analyzer
    • Creating target definitions
      • Automatic target creation
      • Definition importing

Activity: In this activity students will use the source analyzer to build sources from the sample data provided. They will also develop targets for the purpose of migrating the data from its source to a staging table.

Part 5: Introduction to data transformations

  1. Implementing transformations
  2. Transformation types
  3. Transformation views
  4. Expression driven transformations
    • Functions
  5. Variable ports
  6. Data types

Part 6: Working with advanced transformations

  1. Explore the mappings designer
  2. Advanced topics
    • Filter transformations
    • Aggregator transformations
    • Joiner transformations
    • Sorter transformations
    • Lookup transformations

Activity:  Instructor-led demo of PowerCenter Project Management

Activity:  Students will take the result of the activity at the end of day 1 and turn it into a model within PowerCenter. Students will recreate the conceptual model that encompasses all the departments. This will reinforce the ideas of entities and relationships and get students thinking about the complexity of relating data across departments.

Part 7: Introduction to the Metadata Manager

  1. Defining metadata models
    • Metadata defined
    • Types of Metadata
    • Metadata management overview
    • Metadata management lifecycle
  2. Metadata Manager
    • Key features
    • Connector
    • Data lineage
    • Impact analysis
    • Business Glossary
  3. Loading and linking external metadata
  4. Building custom metadata models
  5. Loading business glossaries
  6. Linking glossary terms with technical metadata objects
  7. Browse and search the metadata catalog
  8. Interacting with lineage diagrams

Activity: In this activity students will have the opportunity to work with the Metadata Manager.  Special emphasis will be placed on the data lineage and impact analysis components.

Part 8: Introduction to PowerExchange

  1. Using the PowerExchange Navigator
  2. Introduction to data maps
  3. PowerExchange/PowerCenter integration

Activity: In this activity, the students will work with PowerExchange data maps and experiment with the integration between PowerExchange and PowerCenter

Part 9: Course Conclusion

  1. Recapping what you’ve learned in class
  2. Specific questions and student use cases
  3. What will you do back at work?
  4. Q & A and class closing
Who should attend

This course is designed for anyone in the enterprise utilizing a data component or integrating a data service into their job role or project, and who wish to use Informatica as their tool for doing so. The workshop is invaluable for: 

  • Data engineering and DBA professionals
  • ETL Developers
  • Developers integrating data services for applications
  • Analytics and reporting professionals
  • Business intelligence professionals
  • Data modelers & analysts
  • Data warehousing & data mart staff
  • Cross-functional teams integrating data

This course is designed for organizations who have an Informatica license and can provide the necessary tool environment for the hands-on lab portions of the class. We cannot provide a simulated Informatica environment.