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

 
 
 
 
 
 
Informatica
     
  COURSE ID   GES-ID
  DURATION   39 hrs
  Course Fee   $1500+HST
  DELIVERY METHOD   Classroom Instructor-led training (CILT) Online Instructor-led training ( OILT)
  COURSE OVERVIEW  
  AUDIENCE  
  PREREQUISITES  
  COURSE OBJECTIVES  
  COURSE OUTLINE  

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.

  SOFTWARE  
  CONTACT INFORMATIONwe  

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