Course Overview

This Informatica online training course helps you build your competency at the beginner and intermediate levels of PowerCenter. You will learn about objects and gain practical expertise in the use of Designer, Workflow Manager, and Workflow Monitor tools. You will also master advanced data transformation concepts and the skills of ETL.

Skills Covered

  • Informatica PowerCenter Designer
  • Workflow Manager console
  • Workflow Monitor tool
  • Master source qualifiers
  • Mappings
  • Transformation using IO ports
  • Expression syntax
  • SCD1 SCD2 SCD3 mappings
  • Transformation functions
  • Informatica PowerCenter 9

Training Options

Corporate Training

Customized to your team's needs

  • Blended learning delivery model (self-paced eLearning and/or instructor-led options)
  • Flexible pricing options
  • Enterprise grade Learning Management System (LMS)
  • Enterprise dashboards for individuals and teams
  • 24x7 learner assistance and support

Course Curriculum

Eligibility

This Informatica certification training is designed for ETL and data warehousing professionals, SQL and database developers, business intelligence professionals, mainframe professionals, project managers, and professionals planning to earn the PowerCenter Developer certification.
Read More

Pre-requisites

There are no prerequisites for this training but some useful technology to know includes SQL, databases, and some scripting language.
 
Read More

Course Content

  • Getting Started with Informatica

    Preview
    • Lesson 1 - Downloading Informatica Power Center 9.x

      08:42Preview
      • 1.1 The Course Overview
        03:10
      • 1.2 Downloading the Tool
        02:45
      • 1.3 Extracting the Tool from Its .zip File
        02:47
    • Lesson 2 - Installing and Configuring Power Center

      05:22
      • 2.1 Installing the Server
        04:04
      • 2.2 Installing the Client
        01:18
    • Lesson 3 - Getting Familiar with the Admin Console

      08:58Preview
      • 3.1 Configuring Domain and Node
        04:25
      • 3.2 Configuring Repository and Integration Service
        04:33
    • Lesson 4 - Setting up Security, Permissions, and Client Configuration

      04:47Preview
      • 4.1 Configuring Users and Granting Permissions
        02:01
      • 4.2 Configuring the Repository Manager
        02:46
    • Lesson 5 - Using the Designer Screen

      18:04Preview
      • 5.1 Using the Designer Client Interface
        04:35
      • 5.2 Working with Sources as Files and Databases
        08:49
      • 5.3 Working with Targets as Files and Databases
        04:40
    • Lesson 6 - Creating Mappings

      06:48
      • 6.1 Creating a New Mapping
        04:56
      • 6.2 Getting Acquainted with the Workflow Manager Screen
        01:52
    • Lesson 7 - Adding Transformation Using Input and Output Ports

      06:33
      • 7.1 Using the Workflow Manager Interface
        02:07
      • 7.2 Using the Workflow Manager
        04:26
    • Lesson 8 - Setting Up a Path and Connection

      06:52Preview
      • 8.1 Setting the Source And Target Paths
        03:38
      • 8.2 Executing the Workflow
        03:14
    • Lesson 9 - Getting Accustomed to the Workflow Monitor Screen

      06:28
      • 9.1 The Workflow Monitor
        02:53
      • 9.2 The Workflow Log, Session Log, And Run Properties
        03:35
    • Lesson 10 - Working with the Repository Manager Screen

      11:04
      • 10.1 Copy Paste and Drag Drop Features
        06:42
      • 10.2 The Export Import Feature
        04:22
  • Implementing Informatica PowerCenter 9

    Preview
    • Lesson 1 - Using Transformations

      27:02Preview
      • 1.1 The Course Overview
        01:53
      • 1.2 The Expression Transformation
        08:57
      • 1.3 The Aggregator Transformation
        05:57
      • 1.4 The Sorter Transformation
        03:08
      • 1.5 The Filter Transformation
        02:29
      • 1.6 The Router Transformation
        04:38
    • Lesson 2 - Using Advanced Transformations

      24:22
      • 2.1 The Rank Transformation
        03:07
      • 2.2 The Joiner Transformation
        04:49
      • 2.3 The Union Transformation
        02:59
      • 2.4 The Source Qualifier Transformation
        06:30
      • 2.5 The Sequence Generator Transformation
        06:57
    • Lesson 3 - More Advanced Transformations

      26:35Preview
      • 3.1 Classification of Transformation
        04:04
      • 3.2 The Lookup Transformation
        09:57
      • 3.3 Types of Caches
        06:05
      • 3.4 The Update Strategy Transformation
        02:53
      • 3.5 The Stored Procedure Transformation
        03:36
    • Lesson 4 - Implementing SCD

      21:37
      • 4.1 Understanding SCD Types
        05:32
      • 4.2 Implementing SCD1 Mapping
        08:10
      • 4.3 Implementing SCD2 Mapping
        03:54
      • 4.4 Implementing SCD3 Mapping
        04:01

Exam & Certification

Informatica Powercenter Certificate
  • What do I need to unlock my Simplilearn certificate?

    To obtain the Email Marketing course certification, you must complete 85 percent of the online self-learning course.

  • Disclaimer
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, and OPM3 are registered marks of the Project Management Institute, Inc.