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

Course preview

    • Lesson 1 - Downloading Informatica Power Center 9.x 08:42
      • 1.1 The Course Overview03:10
      • 1.2 Downloading the Tool02:45
      • 1.3 Extracting the Tool from Its .zip File02:47
    • Lesson 2 - Installing and Configuring Power Center 05:22
      • 2.1 Installing the Server04:04
      • 2.2 Installing the Client01:18
    • Lesson 3 - Getting Familiar with the Admin Console 08:58
      • 3.1 Configuring Domain and Node04:25
      • 3.2 Configuring Repository and Integration Service04:33
    • Lesson 4 - Setting up Security, Permissions, and Client Configuration 04:47
      • 4.1 Configuring Users and Granting Permissions02:01
      • 4.2 Configuring the Repository Manager02:46
    • Lesson 5 - Using the Designer Screen 18:04
      • 5.1 Using the Designer Client Interface04:35
      • 5.2 Working with Sources as Files and Databases08:49
      • 5.3 Working with Targets as Files and Databases04:40
    • Lesson 6 - Creating Mappings 06:48
      • 6.1 Creating a New Mapping04:56
      • 6.2 Getting Acquainted with the Workflow Manager Screen01:52
    • Lesson 7 - Adding Transformation Using Input and Output Ports 06:33
      • 7.1 Using the Workflow Manager Interface02:07
      • 7.2 Using the Workflow Manager04:26
    • Lesson 8 - Setting Up a Path and Connection 06:52
      • 8.1 Setting the Source And Target Paths03:38
      • 8.2 Executing the Workflow03:14
    • Lesson 9 - Getting Accustomed to the Workflow Monitor Screen 06:28
      • 9.1 The Workflow Monitor02:53
      • 9.2 The Workflow Log, Session Log, And Run Properties03:35
    • Lesson 10 - Working with the Repository Manager Screen 11:04
      • 10.1 Copy Paste and Drag Drop Features06:42
      • 10.2 The Export Import Feature04:22
    • Lesson 1 - Using Transformations 27:02
      • 1.1 The Course Overview01:53
      • 1.2 The Expression Transformation08:57
      • 1.3 The Aggregator Transformation05:57
      • 1.4 The Sorter Transformation03:08
      • 1.5 The Filter Transformation02:29
      • 1.6 The Router Transformation04:38
    • Lesson 2 - Using Advanced Transformations 24:22
      • 2.1 The Rank Transformation03:07
      • 2.2 The Joiner Transformation04:49
      • 2.3 The Union Transformation02:59
      • 2.4 The Source Qualifier Transformation06:30
      • 2.5 The Sequence Generator Transformation06:57
    • Lesson 3 - More Advanced Transformations 26:35
      • 3.1 Classification of Transformation04:04
      • 3.2 The Lookup Transformation09:57
      • 3.3 Types of Caches06:05
      • 3.4 The Update Strategy Transformation02:53
      • 3.5 The Stored Procedure Transformation03:36
    • Lesson 4 - Implementing SCD 21:37
      • 4.1 Understanding SCD Types05:32
      • 4.2 Implementing SCD1 Mapping08:10
      • 4.3 Implementing SCD2 Mapping03:54
      • 4.4 Implementing SCD3 Mapping04: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


    • 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.