RKG Technologies: ITBiz Training

		1-877-482-0809
		info@training-ITBiz.com

We provide Microsoft Tools, Data Bases, ETL, Business Applications, Project Management, Reporting tools and several other IT courses at our locations or at corporate facilities. We develop and customize training courses for all corporate training needs for IT managers, IT staff and end users. With our experienced faculty and with our proven course development process, we can create an effective curriculum and can fulfill all corporate training requirements.

For further details
Call Us 1-877-482-0809
Or send a message to
info@training-ITBiz.com

Informatica

Informatica Power Center 8.x

Software Version	Informatica Power Center 8.x
Course Duration	5 Days
Course Type	Class Room and Instructor-Led On-Line (E-Learning) Hands-On Training

Course Overview

This intensive course provides the basic skills and knowledge developers new to Informatica PowerCenter require to implement data integration projects, exposing core features of PowerCenter releases 8.0 to 8.6 through lecture and hands-on exercises.. In addition to gaining tremendous insight into the data integration platform, students will be exposed to troubleshooting techniques. After successfully completing this course, students should be able to:

Use PowerCenter 8 Designer to build mappings that move data from sources to targets.
Use PowerCenter 8 Workflow Manager to build and run a workflow that runs a session based on a mapping.
Design mappings and workflows based on business needs.
Perform basic troubleshooting of PowerCenter mappings and transformaitons.
Use Informatica Support options to resolve questions and problems about Informatica PowerCenter 8.

Intended Audience for this course

This course is designed for those who have technical background, knowledge with any computer language, Java, J2EE, XML, .NET Developers, Business Intelligence Developer, Data warehouse Administrator, Data Modelers, End Users, ERP Developers, DBAs, Functional Consultants, IT management and Staff, Business Analysts, Data Warehouse Analysts, Technical Consultants, Students and also those who want to become Informatica consultants.

Course Topics

Overview

Informatica Architecture
Informatica Server
ETL with Informatica
Informatica Suite Components
Informatica Designer
Workflow Monitor
Source Analyzer
Warehouse Designer
Mapping Designer
Mapplets Designer

Transformations in Informatica

Importing sources and Targets
Source Qualifier Transformation
Filter Transformation
Expression Transformation
Aggregator Expression
Router Transformation
Lookup Transformation
Update Strategy
Joiner Transformation
Rank Transformation
Sequence Generator
XML Transformation (Generator & Parser, both)
Creating, Configuring and Linking Ports
Joiner Transformation
Stored Procedure Transformation
Union Transformation
Sorter Transformation
ODBC DSN creation
Designing the ETL
Specifying the Database Connections
Troubleshooting Informatica

Instructor-Led On-Line Classes are designed to use the latest technologies to deliver a highly interactive learning experience. On-Line training is a virtual classroom wherein the teacher and students can share the screens interactively. Instructor can visit student’s computer via remote control during exercises and provide assistance to debug and solve the problems. Instructor-Led On-Line Training (ILT) has several advantages such as convenience and avoiding travel to go to classroom. With an effective instructor and good course design, distance learning can be effective and engaging.