Course Introduction

Informatica is a software development company founded in 1993 .Informatica is a data integration/ETL tool. It gathers data from various sources and loads it into distinctive targets. It just moves data from one place to another, but does not store anything. Informatica utilizes a service oriented architecture, that carries the ability to promote services and resources over various machines.

Learn Basic SQL, After go through Informatica Training as fresher you can apply in IT Company.


Introduction to Informatica

  • Basic Definitions
  • Informatica Products
  • Informatica Architecture
  • Tools and their roles
  • Folders -sub Folders
  • Power Center I Power Malt
  • Introduction to designer

Informatica Designer 

  • Designer interfaces
  • Designer tools
  • Defining Sources
  • (i) Database as a source
  • (ii) Rat Flies sources
  • Defining Targets
  • Importing from database
  • Creating a new target
  • Creating target database objects
  • Mapping Introduction
  • Source Qualifier
  • Ports
  • Mapping -Table to Table
  • Mapping flat File to Table
  • Connected/Unconnected Transformations
  • Active and Passive Transformation
  • Source Qualifier Transformation
  • SQl Override-Source Qualifier Transformation

Mapping Source Qualifier as Filter

  • Source qualifier to join Data
  • Filter Transformation
  • Expression Transformation
  • Sequence Generator Transformation
  • Rank Transformation
  • Router Transformation
  • Aggregator Transformation
  • Joiner Transformation
  • Stored procedure Transformation (Connected & Unconnected)
  • Union Transformation
  • XMl Transformation
  • Mapping Wizards
  • Implementing Type-I, Type-II, Type-III
  • Mappings
  • Workflow Introduction

Informatica - workflow Manager Task

  • Workflow tools
  • Connections
  • Defining tasks
  • (i) Command Task
  • (ii) Email Task
  • (iii) Session Task
  • (iv) Link Conditions
  • (v) Event Wait & Event Raise
  • Setting Properties of Session Task
  • Creating Workflow
  • Starting Workflow
  • Monitoring Workflow
  • Incremental Aggregation

Informatica Advanced Features

  • Mapplet Implementation
  • Target Load Plan
  • Constraint based Loading
  • Mapping Parameters
  • Mapping Variables

Leave A Message

There are no any courses offered by this institute...!