|
Place a bid
Jumpstart Your Career
Learn the Informatica PowerCenter ETL Tool
In today's market Informatica Powercenter professionals are in demand. Don't believe it? Do a search on any of the major job boards and look at the results.
Our Introduction to Informatica 7 course will get you up to speed on the essentials of Informatica PowerCenter quickly using hands on exercises.
This training course includes a 150+ page workbook and CD-ROM containing all files, data and solutions to the exercises needed to become a fully functional Informatica programmer.
Buy Today and get 3 days access to my Informatica server to work through the examples in the workbook.
Course Outline
Technical Architecture and Overview
What is PowerCenter?
Server and Clients components
Developing in PowerCenter
The PowerCenter Repository
What is the PowerCenter Repository?
Understand the objects stored in the Repository
Security and Authentication
Managing Users Locks and Connections
Sources and Targets
Overview of the various Sources and Targets
Importing a Source
Create a Source and Target manually
Create a Target from a Source
Mappings Overview
Creating an Informatica Mapping
Passive and Active Transformations
Using Ports
Expressions
Workflows and Sessions
Using Workflow Manager and Workflow Monitor
Tasks, Sessions and Workflows
Scheduling your Workflows
Reference Lookups and Sequence Generators
Lookup Transformation: Connected and Disconnected
SQL Overrides and caching
The Sequence Transformation
Troubleshooting
Workflow and Session logs
Tracing Levels
Using the Debugger
Advanced Target Properties
Different options to populate a Target
Using the Update Strategy
Row Indicators and rejected rows
Other Transformation Types
Using additonal Informatica transformations
Understanding performance implications
Advanced Mapping Concepts
Importing and Exporting objects from the Repository
Using Parameter Variables
Understanding Server Variables
Understanding Session Variables
Reusable Transformations and Mapplets
Reusable Transformations
Mapplets
Shortcuts
Reusable Tasks and Worklets
Reusable Tasks
Worklets
|