Jumpstart Your Career

Learn the Informatica PowerCenter ETL Tool

*** Click Here To Download Your Ebook ***

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.

Course Outline

1. Technical Architecture and Overview
   • What is PowerCenter?
   • Server and Clients components
   • Developing in PowerCenter
2. The PowerCenter Repository
   • What is the PowerCenter Repository?
   • Understand the objects stored in the Repository
   • Security and Authentication
   • Managing Users Locks and Connections
3. 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
4. Mappings Overview
   • Creating an Informatica Mapping
   • Passive and Active Transformations
   • Using Ports
   • Expressions
5. Workflows and Sessions
   • Using Workflow Manager and Workflow Monitor
   • Tasks, Sessions and Workflows
   • Scheduling your Workflows
6. Reference Lookups and Sequence Generators
   • Lookup Transformation: Connected and Disconnected
   • SQL Overrides and caching
   • The Sequence Transformation
7. Troubleshooting
   • Workflow and Session logs
   • Tracing Levels
   • Using the Debugger
8. Advanced Target Properties
   • Different options to populate a Target
   • Using the Update Strategy
   • Row Indicators and rejected rows
9. Other Transformation Types
   • Using additonal Informatica transformations
   • Understanding performance implications
10. Advanced Mapping Concepts
    • Importing and Exporting objects from the Repository
    • Using Parameter Variables
    • Understanding Server Variables
    • Understanding Session Variables
11. Reusable Transformations and Mapplets
    • Reusable Transformations
    • Mapplets
    • Shortcuts
12. Reusable Tasks and Worklets
    • Reusable Tasks
    • Worklets

Secure Payment Using Your Credit Card

Secure Payment Using Paypal