Informatica 9.6.x: Data Warehousing

The WebLearning Data Warehousing using Informatica 9.6.x course provides hands-on step-by-step instructions on how to perform a variety of Data Warehousing 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, learn how to plan, build and deploy a Data warehouse using Informatica 9.6.x as your primary ETL Tool for developing Extract, Transform and Load processes.

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

Course Objectives for Informatica 9.6.x:

• Understand the Informatica Data Warehouse and ETL Development Lifecycle
• Understand the BI and Warehouse Development Process
• Learn to Manage Informatica Warehouse Projects
• Understand Data warehousing Concepts
• Understand Dimension Modelling
• Understand Data Quality Issues in ETL Process
• Understand the architecture of the Informatica system
• Manage your Informatica environment using the Informatica Console
• Use PowerCenter 9.x Designer to build mappings
• Use PowerCenter 9.x Designer to 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