EncartaLabs

Informatica PowerCenter Data Integration for Developers

( Duration: 2 Days )

The Informatica PowerCenter - Data Integration for Developers training course provides delegates with the skills and knowledge necessary to design, build, test, and maintain real-world data integration systems with PowerCenter's workbench tools. Delegates will learn how to create and combine PowerCenter objects such as source and target definitions, data transformations, mappings, sessions, and workflows in order to accomplish their project goals while using best-practice methodology.

By attending Informatica PowerCenter - Data Integration for Developers workshop, delegates will learn to:

  • Use the PowerCenter Designer interface to design data transformations.
  • Manage a variety of source and target definitions.
  • Filter, join, aggregate, categorize, merge, and apply expression logic to data without writing SQL.
  • Monitor and repair PowerCenter Sessions and Workflows.
  • Troubleshoot mapping problems with the debugger.
  • Leverage object reusability (build-once, use everywhere)
  • Benefit from specific Agile Data Integration best practice techniques.

  • Developers

COURSE AGENDA

1

Introduction to PowerCenter

  • How PowerCenter performs data integration
  • Advantages of code-free and SQL-free development
  • Informatica architecture
  • PowerCenter components and applications
  • PowerCenter object types
2

Folders, Sources, and Targets

  • PowerCenter folder types
  • Folder best practices
  • Source definition types and methods of creation
  • Target definition types and methods of creation
  • Benefits of object shortcuts
3

Design Objects

  • Fundamental mapping components
  • Transformation types
  • Mapping types
  • PowerCenter expressions and port types
  • Filtering records
4

File Lookups

  • Fundamentals of the Lookup transformation
  • How to create a lookup on file data
  • Joining heterogeneous data
  • Multi-return lookups
  • Bypassing transformations
5

Relational Lookups

  • How to create a lookup on relational data
  • Understanding lookup connectivity
  • Port default values
  • Variable ports
  • Refreshing mapping metadata
6

Database Joins in PowerCenter

  • Getting the database to join data
  • Reusable transformations
  • Target Load Plan
  • Multi-pipeline mappings
  • Workflow link conditions
7

Workflow Logic

  • Using Session pre-defined variables
  • Using Decision Tasks
  • Using Email Tasks
  • Sending email from within a Session
8

Merging, Routing, and Sorting Data

  • Merging mapping pipelines
  • Removing duplicate records
  • Classifying data with the Router transformation
  • Renaming Source Qualifier ports
9

Command Tasks

  • Running command line statements within a Workflow
  • Lookup caching properties
  • Persistent lookup caches
  • Aliasing a lookup port
10

Debugging

  • When to use the debugger utility
  • Launching and configuring the debugger
  • Debugger features and techniques
11

Parameterization

  • How and when to parameterize values and properties
  • Using a parameter file
  • When to use an unconnected lookup
  • Using a Sequence Generator transformation
12

Updating Database Tables

  • How to update and delete from relational database tables
  • Perform insert-else-update logic with the Update Strategy transformation
  • Understanding built-in connection variables
  • Creating and using Worklets
  • Timer Tasks
  • Control Tasks
13

Mapplets

  • Creating and using Mapplets
  • Mapplet types and limitations
  • Aggregator transformations
14

Mapping Design Workshop

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 4,000 Modules on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting http://encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top