Course Description

  • What’s the focus of this course?

    This Informatica training by Simplilearn equips you with all skills required to step into the field of ETL and data warehousing using the most in-demand tool. Informatica PowerCenter. This course builds your competency in developing beginner to intermediate level of PowerCenter objects and to expertise in the practical use of the Designer, Workflow Manager, Workflow Monitor tools, and master advanced transformations concepts.

  • What are the course objectives?

    After completing this course you will be able to:

    • Understand Basic Mapping Design including the use of Informatica PowerCenter Designer, Workflow manager, and workflow monitor tool
    • Master source qualifier, expression, aggregator, lookup, filter, joiner and other kinds of transformations
    • Add transformations using input and output ports
    • Work with transformation functions and expression syntax
    • Implement SCD1, SCD2, and SCD3 mappings

  • Who should take this course?

    This course is perfect for taking your initial steps into the field of ETL and data warehousing. This training is designed for:

    • ETL and data-warehousing professionals
    • SQL and database Developers
    • Business Intelligence Professionals
    • Mainframe Professionals
    • Project Managers
    • Professionals planning to appear for the Powercenter Developer Certification

  • What are the prerequisites for this course?

    There are no prerequisites for this training but some good to know topics are SQL, databases and some scripting language

  • How will I execute the hands-on practicals?

    The hands-on will be executed using the Informatica cloud trial version. Use this link to access
    https://www.informatica.com/trials/informatica-cloud.html#fbid=7d5xuU5hKyf

Course Preview

    • Lesson 1 - Downloading Informatica Power Center 9.x

      08:42
      • 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:58
      • 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:47
      • 4.1 Configuring Users and Granting Permissions
        02:01
      • 4.2 Configuring the Repository Manager
        02:46
    • Lesson 5 - Using the Designer Screen

      18:04
      • 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:52
      • 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
    • Lesson 1 - Using Transformations

      27:02
      • 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:35
      • 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
    • {{childObj.title}}

      • {{childObj.childSection.chapter_name}}

        • {{lesson.title}}
      • {{lesson.title}}

    View More

    View Less

Exam & Certification

  • Exam & Certification

    Online Self Learning
    The following criteria must be met for successful completion of the course and certificate unlock:

    • Complete 85% of the course

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