Course Description
Exist Management LLC (ExistBI) is a Certified and Approved Informatica University training partner in the United States, Canada, United Kingdom and Europe with the permission to deliver onsite or live instructor-led online Informatica PowerCenter training anywhere around the globe.
We deliver fit for purpose and the official four-day live instructor-led Informatica PowerCenter training, Level 1 Developer that introduces delegates to PowerCenter through lecture and hands-on labs. This course is designed for ETL Developers who have no or little experience using this comprehensive PowerCenter tool. The software is used by Developers to create, execute, monitor and schedule ETL processes.
Course Outcomes
At the end of the course, learners will be able to:
- Use the PowerCenter Designer interface to design data transformations.
- Manage a variety of source and target definitions.
- Filter, join, aggregate, categorize, merge, and apply expression logic to data without writing SQL.
- Monitor and repair PowerCenter Sessions and Workflows.
- Troubleshoot mapping problems with the debugger.
- Leverage object reusability (build-once, use everywhere)
- Benefit from specific Agile Data Integration best practice techniques.
Course Summary
Next Public Course Dates | |
| Prerequisites |
|
| Duration |
|
| Available Formats |
|
| Audience |
|
Testimonials
The course was comprehensive and interactive, and the trainer really understood the content. I have been able to implement much of what I learned into my daily work activities and have saved a lot of time.
, Advocate Health Care
Hands-down the best technical training I have taken! The methods of progressively building reports, adding complexity and features as time goes on, was fantastic.
, Cirrus Aircraft
Course Modules
Introduction to PowerCenter
- How PowerCenter performs data integration
- Advantages of code-free and SQL-free development
- Informatica architecture
- PowerCenter components and applications
- PowerCenter object types
- Terminology, Tools GUI, Mappings, Transformations, Sessions, Workflows and Workflow Monitor
Command Tasks
- Running command line statements within a Workflow
- Lookup caching properties
- Persistent lookup caches
- Aliasing a lookup port
