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

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

Understand Master Data Management and quality control within the integration process

Utilizing transform phase to address common problems

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

Identify data integration requirements

Informatica value proposition

Why use Informatica?

Data Integration Architecture

Explore the Informatica architecture

Informatica use cases

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

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

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

Implementing transformations

Transformation types

Transformation views

Expression driven transformations

Functions

Variable ports

Data types

Part 6: Working with advanced transformations

Explore the mappings designer

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

Defining metadata models

Metadata defined

Types of Metadata

Metadata management overview

Metadata management lifecycle

Metadata Manager

Key features

Connector

Data lineage

Impact analysis

Business Glossary

Loading and linking external metadata

Building custom metadata models

Loading business glossaries

Linking glossary terms with technical metadata objects

Browse and search the metadata catalog

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

Using the PowerExchange Navigator

Introduction to data maps

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

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:

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.

Download the brochure

First Name

Last Name

Email

State

Job Title

Company Name

How did you hear about us?

On

Want to learn more about this course or need a custom solution?

Contact us now to speak with an enterprise specialist for more information about this course or to create a solution tailored to the needs of your organization.