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