Informatica


Informatica Course Content

Overview:
Informatica is one of the widely used ETL Tool for extracting the source data and loading it into the target after applying the required transformation. It provides a single enterprise data integration platform to help organization access, transform, and integrate data from a large variety of systems and deliver information to other transactional systems.
Training Objectives of Informatica:
Informatica Supports the activity Process of the Business Integration Competency Center (ICC) and other integration experts by Serving as the foundation for data warehousing, data consolidation, migration, “single-view,” metadata management and synchronization. The Course we provide will give you Advance skills and Advance development knowledge to developers. In addition students shall be exposed to “Performance Oriented tuning techniques”, and some special features of the Tool.
Target Students and Prerequisites:
Students must have basic knowledge on Data Ware housing and SQL and PL/SQL Concepts. Students must be familiar with Concepts in Oracle database and its functionality.
Introduction
Overview
Basic Definitions
Informatica products
Informatica Architecture
Tools and their roles
Folders-Sub folders
Power center / Power mart
Infomatica Designer – Introductiion
Introduction to Designer
Logon to Designer
Designer interfaces
Designer Tools
Defining Sources
Database as a source
Flat File sources
Defining Targets
Importing from database
Creating a new target
Creating target database objects
Informatica Designer
Mapping Introduction
Source Qualifier
Ports
Mapping – Table to Table
Mapping Flat File to Table
Connected /Unconnected Transformations
Active and Passive Transformations
Source Qualifier to join Data
Filter Transformation
Expression Transformation
Sequence Generator Transformation
Rank Transformation
Router Transformation
Aggregator Transformation
Joiner Transformation
Stored Procedure Transformation(Connected and Unconnected)
Union Transformation
XML Transformation
Mapping Wizards
Implementing Type-I,Type-II,Type-III Mappings
Informatica – Workflow Manager
Workflow Introduction
Tasks
Workflow tools
Connetions
Defining tasks
Command Tasks
Email Task
Session Task
Link Conditions
Event Wait & Event Raise
Setting Properties of Session Task
Creating Workflow
Starting Workflow
Monitoring Workflow
Informatica Advanced Features
Incremental Aggregation
Mapplet Implementation
Target Load Plan
Constraint Based Loading
Mapping Variable
Session Parameters
Link Conditions
Reusable Transformation
Task and Types of Tasks
Work let and Types of work lets
Scheduling Workflow
Control flow using Command task and event wait task
Incremental Loading