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
-
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
Secure Payment Using Your Credit Card
Secure Payment Using Paypal