Home  |  About Us  |  Careers |  Resources  |  Client List  |  Sitemap  |  Contact Us

Call: 416-623-9493 or 905-497-8717

Toll Free: 1-866-955-4526
E-mail: info@globalerp.ca

Software Quality Assurance Training Business Analysis Training SAP Training BI Development Microsoft BI Training PMP Training Tableau Training Informatica Training JAVA Training MICROSOFT .NET Training Power BI Training Big Data & Hadoop Training Scrum Training DevOps Training Cyber Security ORACLE Admin Training

  DURATION   39 hrs
  Course Fee   $1500+HST
  DELIVERY METHOD   Classroom Instructor-led training (CILT) Online Instructor-led training ( OILT)

1. Terminology and Architecture


- Explain the purpose of Informatica PowerCenter

-Define terms used in PowerCenter

-Name major PowerCenter components and describe their functions


2. Mapping Fundamentals


-Create Source and Target Definition objects from flat files and relational tables.

-Create a Mapping using existing source and target definitions

-Use links to connect ports


3. Workflow basics


-Create a Workflow and link its tasks

-Run a workflow monitors its execution and verify the results


4. Expressions and Filters


-Use expression transformations to perform calculations on a row by row basis

-Use filter transformations to pass rows based on user defined conditions


5. Joining and Merging Data.


-Use pipeline branches in Mappings

-Join homogeneous sources using the source qualifier transformation

-Define heterogeneous joins using the joiner transformation

-Merge records from multiple places to one record set using the Union transformation


6. Lookup Transformation


-Use lookup transformations to bring in additional data related to a row

-Use unconnected lookup transformations to provide values on, as needed basis


7. Sorter and Aggregator Transformations


-Calculate values based on data in a set of records using the Aggregator transformation

-Order a set of records based on one or more fields using the aggregator transformation


8. Updating target tables


-Use an update strategy transformation to determine how the target should handle records (insert, update, delete)


9. Debugger


-Use the Debug wizard and toolbar to debug a mapping.


10. Mapping Techniques


-Set and use system and Mapping variables and parameters

-Creates and use reusable’s transformations

-Use a Router transformation to divide a single set of records into multiple sets of records.


11. Mapplets and worklets


-Describe Mapplets

-Know how to use mapplet output transformations and output groups.

-Know the rules regarding active and passive mapplets

-Use mapplets in Mappings

-Describe worklets


12. Controlling workflows


-Set and use workflow variables

-Use link conditions and decision tasks to control the execution of a workflow

-Create and use other workflow tasks including email. Event Wait, Event Raise and Command

-Explain the purpose of the pmomd utility

-Schedule workflow to run automatically


13. Mapping Design


-Follow recommended best practices for Mapping Design


14. Workflow Design.


A follow recommended best practices for workflow design.


Brampton:199 Advance Blvd, Suite: 201
..................Brampton, ON, L6T 4N2

Toronto:5635 Yonge St. Suite 215
..................North York (Finch Subway) ON M2M 3S9

Mississauga:1065 Canadian Place, Suite 201
..................Mississauga ON L4W 0C2

Phone: 416-623-9493 or 905-487-4500
E-mail: training@globalerp.ca