תנאי השתתפות- ידע ב-SQL חובה + הכרות עם ה-database
משך הקורס - 5 ימים (4-8/01)
שעות לימוד - 16:00 - 08:00
היקף הקורס- 40שעות, 5מפגשים
מיקום הקורס - בית סלע, רח' ברוך הירש 14, בני ברק
חנייה - ללא תשלום בחניון קניון אילון
אוטובוסים המגיעים לקניון איילון בר"ג .
אגד - 75,524,525 (תחנה מרכזית תל-אביב)
דן - 52,57,67,92,4,20,27 (23,40,42 מתחנת רכבת תל-אביב צפון)
לכל המעוניינים להשתתף - נא לשלוח מייל ל-
להלן הסילבוס של הקורס:
PC8.x Level 1 Developer (7/08)
Course Description
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
Explain the purpose of PowerCenter
Define terms used in PowerCenter
Name the major components of PowerCenter
2. Mapping Fundamentals
Create source and target definitions from flat files and relational tables
Create a mapping using existing source and target definitions
Use links to connect ports
3. Workflow Fundamentals
Create a basic workflow and link its tasks
Run a workflow, monitor its execution,and verify the results
4. Expression and Filter Transformations
Use expression xformations to perform calculations on a row-by-row basis
Use filter xformations to drop rows based on user-defined conditions
(unnumbered) Demonstration of Techniques
Use a variety of techniques to work more efficiently in PowerCenter
5. Joining and Merging Data
Use Source Qualifier xformation to implement homogeneous joins
Use Join xformation to implement heterogeneous joins
Use Union xformation to merge records into a single record set
6. Lookup Transformation
Use lookup xformations to bring in additional data related to a row
7. Aggregator and Sorter Transformations
Order a set of records based on one or more fields using the Sorter xformation
Calculate values based on data in a set of records using the Aggregator xformation
8. Using the debugger
Use the Debug wizard and toolbar to debug a mapping
9. Updating Target Tables
Use a router xformation to divide a single set of records into multiple sets of records
Use an update strategy xformation to determine how the target should handle records (insert/update/delete)
10. Mapping Techniques
Set and use variables and parameters
Create and use reusable transformations
Use an unconnected lookup to provide values on an as-needed basis
11. Mapplets
Create mapplets and incorporate them into mappings
12. Controlling Workflows
Set and use workflow variables
Use link conditions and decision tasks to control the execution of a workflow
Use other workflow tasks
Explain the purpose of the pmcmd utility
Correctly use bulk and normal loading
Schedule workflows to run automatically
13. Mapping Design Workshop
Follow best practices for mapping design
Create a mapping based on defined business needs
14. Workflow Design Workshop
Follow best practices for workflow design
Create a workflow based on defined business needs