Informatica Training in Chennai

 Home    IT Training    Informatica Training in Chennai 

Informatica Training in Chennai

Informix® is a relational database and for almost 20 years was also the name of the company who developed it. Informix DBMS was a development of the pioneering Ingres system that also led to Sybase and SQL Server, and was the #2 database system behind Oracle for some time in the 1990s. Their brush with success was surprisingly short-lived however, and by 2000 a series of management blunders had all but destroyed the company.

IBM’s acquisition of the brand in 2001 caused a seismic shift in the technical support, marketing and future of the Informix® products. However, with IBM’s excellent track record of sustained product maintenance, there is now a bright and assured future for Informix.

Relational Database Systems, Inc. (which became Informix® Software Inc at the time the company went public in 1986), was formed in 1980, when its founders pioneered what is known as C-ISAM – a complex keyed-ISAM system for the storage and fast retrieval of data. It was the company’s first relational database server, branded as Informix® (a combination of ‘Information’ and ‘UNIX’), that became successful enough to trigger the company to change its name accordingly.

Informatica Training Syllabus:

Introduction to Datawarehousing

  • Datawarehousing Overview
  • Datawarehousing concepts
  • Datawarehousing Architecture

Introduction to Informatica

  • Overview
  • Basic definitions
  • Informatica architecture
  • Tools and their roles
  • Folders – Sub Folders
  • Power center / Power mart
  • Differences between 7x and 8x

Informatica Designer

  • Introduction to designer
  • Designer interfaces
  • Designer interfaces
  • Designer tools
  • Defining sources
    • Database as a source
    • Flat Files 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 transformation
  • SQL override in 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 and Unconnected Transformation
  • Union Transformation
  • XML Transformation
  • Mapping Wizards
  • Implementing Type –I, Type-II and Type-III mappings

Informatica Workflow Manager

  • Workflow Introduction
  • Tasks
  • Workflow Tools
  • Connections
  • Defining Tasks
    • Command Task
    • Email Task
    • Session Task
    • Link Conditions
  • 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 Parameters
  • Mapping Variables
  • Session Parameters
  • Link Conditions
  • Copying Repository
  • Deleting Repository
  • Creating Folders

Course Duration:  2  to  3 Month, 2 hpd

Contact:  +91  9080334727


Click here for Offer

Training Courses

Communication Classes

Foreign Language Classes

Indian Regional Classes

Top IT Courses