This 5 day course will give delegates a thorough study on using the Informatica ETL tool.
The course will be begin with an introduction to Informatica PowerCenter 9.6. The course will introduce attendees to working with the PowerCenter Designer, Workflow Manager, and Workflow Monitor tools, performing tasks such as creating transformations, mappings, reusable objects, sessions and workflows to extrac, transform and load data. You will develop cleansing, formatting, sorting and aggregating procedures. You can learn how to use routers, update strategies, parameters /variables and overrides. This course will cover many different types of lookups, such as cached, persistent, dynamic and multiple row returns. Workflow tasks will be created to define a set of instructions for executing the ETL. The course will include hands-on exercises.
Come enjoy the motivating atmosphere, learning with your peers while you discover the possibilities of the Informatica PowerCenter
Audience: Data Analysts, Business Analysts, Developers, Data Managers, Business Intelligence Analysts, IT Administrators, Data Architects
Recommended Prerequisites: None
Course Schedule: 5 Days, 40 Academic Hours