Informatica

COURSE ID

GES-ID
DURATION 39 hrs
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.

Recent comments

Paul

"I have undergone Informatica training in Globalerp solutions, I have gained a good knowledge about the Informatica Thanks you Globalerp solutions"

Mohammad

"Highly skilled & knowledgeable teaching staff. Good infrastructure & excellent placement staff."

jain

"I have joined Informatica course In Globalerp solution.faculties is Very Good Explaining way of Teaching,I assured sincerely refer to My friends."