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

FAQs

  • Who delivers the training?

    All our trainers are certified and are highly qualified, with multiple years of experience in working in ETL, data-warehousing and Informatica.

  • Is this live training, or will I watch pre-recorded videos?

    All the classes are live. They are interactive sessions that enable you to ask questions and participate in discussions during the class time. We do, however, provide recordings of each session you attend for your future reference.

  • Can I cancel my enrollment? Do I get a refund?

    Yes, you can cancel your enrollment if necessary. We will refund the course price after deducting an administration fee. To learn more, you can view our Refund Policy.

  • Are there any group discounts for classroom training programs?

    Yes, we have group discount options for our training programs. Contact us using the form on the right of any page on the Simplilearn website, or select the Live Chat link. Our customer service representatives will give you more details.

  • What payment options are available?

    Payments can be made using any of the following options. You will be emailed a receipt after the payment is made.

    • Visa Credit or Debit card
    • MasterCard
    • American Express
    • Diner’s Club
    • PayPal

  • I’d like to learn more about this training program. Who should I contact?

    Contact us using the form on the right of any page on the Simplilearn website, or select the Live Chat link. Our customer service representatives will give you more details.

  • What is Global Teaching Assistance?

    • Our teaching assistants are here to help you get certified in your first attempt.
    • They are a dedicated team of subject matter experts to help you at every step and enrich your learning experience from class onboarding to project mentoring and job assistance.
    • They engage with the students proactively to ensure the course path is followed.
    • Teaching assistance is available during business hours.

  • What is covered under the 24/7 Support promise?

    • We offer 24/7 support through email, chat, and calls.  
    • We also have a dedicated team that provides on-demand assistance through our community forum. What’s more, you will have lifetime access to the community forum, even after completion of your course with us.

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