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

Common MapReduce Algorithms :

  • Sorting and Searching
  • Indexing
  • Classification/Machine Learning
  • Term Frequency – Inverse Document Frequency
  • Word Co-Occurrence
  • Hands-On Exercise: Creating an Inverted Index
  • Identity Mapper
  • Identity Reducer
  • Exploring well known problems using MapReduce applications

Usining HBase :

  • What is HBase?
  • HBase API
  • Managing large data sets with HBase
  • Using HBase in Hadoop applications
  • Hands-on Exercise

Courses Duration : 3-4 weeks