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 - Basic Mapping Design
      • 1 Use of the PowerCenter Designer Tool
      • 2 Use of the PowerCenter Workflow Manager Tool
      • 3 User of the PowerCenter Workflow Monitor Tool
      • 4 Source Qualifier Transformation
      • 5 Expression Transformation
      • 6 Aggregator Transformation
      • 7 Lookup Transformation
      • 8 Filter Transformation
      • 9 Joiner Transformation
      • 10 Union Transformation
      • 11 Update Strategy Transformation
      • 12 Mapplets
      • 13 User Defined Functions
      • 14 Active versus Passive transformations
    • Lesson 2 - Optimal Mapping Design
      • 1 SQL Overrides
      • 2 Stored Procedure Transformation
      • 3 Unconnected Lookup Transformation
      • 4 XML Transformation
      • 5 HTTP Transformation
      • 6 Transaction Management with Active Transformations
      • 7 Java Transformation
      • 8 Normalizer Transformation
      • 9 SQL Transformation
    • Lesson 3 - Parameters and Variables
      • 1 Variable Assignment
      • 2 Parameter Files
    • Lesson 4 - Expression syntax
      • 1 Transformation Functions
    • Lesson 5 - Troubleshooting
      • 1 Practical Experience
      • 2 PowerCenter Workflow Monitor
      • 3 Log Management
    • Lesson 6 - Workflows and Worklets
      • 1 Workflows
      • 2 Worklets
      • 3 Workflow Tasks
    • Lesson 7 - Architecture
      • 1 Domain and Node Architecture
      • 2 Informatica PowerCenter Commands
    • {{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.

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

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