Informatica PowerCenter: Developer Level 1

  1. Next course On demand
  2. Send inquiry

This course is applicable to software version 10. Explore Informatica PowerCenter 10 which is comprised of server and client workbench tools used to create, execute, monitor and schedule ETL processes. Work through the PowerCenter Designer, Workflow Manager, and Workflow Monitor tools.

As a regional Informatica partner, Poslovna inteligencija offers Informatica official courses held by experienced and certified Informatica consultants.

This course is applicable to software version 10. Explore Informatica PowerCenter 10 which is comprised of server and client workbench tools used to create, execute, monitor and schedule ETL processes. Work through the PowerCenter Designer, Workflow Manager, and Workflow Monitor tools while performing tasks such as creating source and target definitions, transformations, mappings, reusable objects, sessions and workflows to extract, transform and load data.

OBJECTIVES

After successfully completing this course, attendees should be able to:

  • Utilize PowerCenter 10 Designer to build mappings that extract data from a source to a target, transforming it as necessary
  • Deploy PowerCenter transformations to cleanse, format, join, aggregate and route data to appropriate targets
  • Perform error handling/trapping using PowerCenter mappings
  • Use PowerCenter 10 Workflow Manager to build and run workflows which execute sessions associated with a mapping and to control data transformation processes.
  • Design and build simple mappings and workflows based on essential business needs
  • Complete basic troubleshooting using PowerCenter logs and debugger

AUDIENCE

Developer

PREREQUISITES

None

COURSE CONTENT

  1. An Overview of Informatica PowerCenter
  2. ETL Fundamentals
  3. Troubleshooting
  4. PowerCenter Transformations, Tasks and Reusability
  5. Features and Techniques
  6. Joins and Link Conditions
  7. Using the Debugger
  8. Sequence Generators, Lookups and Additional Workflow Tasks
  9. Update Strategies, Routers and Overrides
  10. Sorting and Aggregation Data Using PowerCenter
  11. Mapping Design Workshop
  12. Workflow Design Workshop

 

Find more about course on Informatica University website



Warning: Creating default object from empty value in /home/customer/www/inteligencija.com/public_html/wp-content/themes/inteligencija/includes/courses.php on line 57

You are interested in this course? Ask us for more info!