Vi leverer   ›   Kurs   ›   Kurskalender

PC8XL1D - PowerCenter 8.x Level 1 Developer

This four-day, instructor-led course provides the basic skills and knowledge developers new to Informatica PowerCenter require to implement data integration projects, exposing core features of PowerCenter through lecture and hands-on exercises.. In addition to gaining tremendous insight into the data integration platform, students will be exposed to Informatica Velocity Best Practices, troubleshooting techniques, and the use of technical support options. The course concludes with workshops in which students design and implement a data integration project based on business requirements.

Course Objectives
After successfully completing this course, students should be able to:

• Use PowerCenter 8 Designer to build mappings that move data from sources to targets
• Use PowerCenter 8 Workflow Manager to build and run a workflow that runs a session based on a mapping
• Design mappings and workflows based on business needs
• Perform basic troubleshooting of PowerCenter mappings and transformaitons
• Use Informatica Support options to resolve questions and problems about Informatica PowerCenter 8

Course agenda:

1. Power Center: Terminology and Architecture
   
2. Mapping Fundamentals
   
3. Workflow Fundamentals
   
4. Expression and Filter Transformations
   
5. Demonstration of Techniques
   
6. Joining and Merging Data
   
7. Lookup Transformation
8. Aggregator and Sorter Transformations
   
9. Updating Target Tables
   
10. Using the debugger
    
11. Mapping Techniques
    
12. Mapplets
    
13. Controlling Workflows
    
14. Mapping Design Workshop
    
15. Workflow Design Workshop
    
    

Audience:
PowerCenter developers