Informatica 9.6.x: ETL/ELT Development

The WebLearning Informatica 9.6.x Data Integration and ETL Development course provides hands-on step-by-step instructions on how to perform a variety of Data Integration and ETL Transformation tasks using Informatica in an Oracle Database environment for activities based on real-life work scenarios. 

Using the Informatica ETL Tools, Informatica PowerCenter developers and administrators will learn about the Informatica 9.x architecture, introduce you 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 extract, 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.

Using the Informatica ETL Tools, Informatica PowerCenter developers and administrators will learn about the Informatica 9.x architecture, introduce you 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 extract, transform and load data. You will develop cleansing, formatting, sorting and aggregating procedures.

On successful Completion of this course you will be able to:

Course Objectives for Informatica 9.6.x:

• Learn to Plan and Scope your ETL/ELT Projects
• Understand the ETL Development Lifecycle
• Understand basic Data warehousing Concepts
• Understand basic Dimension Modelling
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the complete Informatica system
• Design and build simple mappings and workflows
• Use PowerCenter 9.x Designer to build mappings that extract data from a source to a target
• Use PowerCenter 9.x Designer to build transformations
• Use PowerCenter transformations to cleanse, format and join data
• Use PowerCenter transformations to aggregate and route data to targets
• Perform error handling/trapping using PowerCenter mappings
• Describe the use of Mapping Variables and Parameter Files
• Use PowerCenter 9.x Workflow Manager to build and run a workflow
• Use PowerCenter 9.x Workflow Manager to execute sessions associated with a mapping
• Perform basic troubleshooting using PowerCenter logs and debugger