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.

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

Mail:  info@velgrotechnologies.com