Informatica Powercenter Certification Training - Simplilearn | IT Training & Certification | Info Trek
Respect Your Dreams
Follow through on your goals with courses

Informatica Powercenter Certification Training - Simplilearn

  • On Demand Class Icon
    On Demand
    • HRDF SBL Claimable
    • Certificate of Attendance available
    • 180 days of access from date of purchase
    Starting From
    RM 1285.70
    0 Hours
  • Private Class Icon
    Private Class
    • All of our private classes are customized to your organization's needs.

      Click on the button below to send us your details and you will be contacted shortly.
    0 Days

Course Details

Expand All
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.

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


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

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


Modules

Expand All

• The Course Overview

• Downloading the Tool
• Extracting the Tool from Its .zip File

• Installing the Server

• Installing the Client


• Configuring Domain and Node

• Configuring Repository and Integration Service


• Configuring Users and Granting Permissions

• Configuring the Repository Manager


• Using the Designer Client Interface

• Working with Sources as Files and Databases

• Working with Targets as Files and Databases


• Creating a New Mapping

• Getting Acquainted with the Workflow Manager Screen


• Using the Workflow Manager Interface

• Using the Workflow Manager


• Setting the Source And Target Paths

• Executing the Workflow


• The Workflow Monitor

• The Workflow Log, Session Log, And Run Properties


• Copy Paste and Drag Drop Features

• The Export Import Feature


• The Course Overview

• The Expression Transformation

• The Aggregator Transformation

• The Sorter Transformation

• The Filter Transformation

• The Router Transformation


• The Rank Transformation

• The Joiner Transformation

• The Union Transformation

• The Source Qualifier Transformation

• The Sequence Generator Transformation


• Classification of Transformation

• The Lookup Transformation

• Types of Caches

• The Update Strategy Transformation

• The Stored Procedure Transformation


• Understanding SCD Types

• Implementing SCD1 Mapping

• Implementing SCD2 Mapping

• Implementing SCD3 Mapping


Trainers

See All
Reset

Reviews

0
based on 0 ratings reviews