Informatica Online Training Hyderabad India

Click Here For Course Content.

Introduction to informatica online training

Informatica is a service oriented Architecture and has the capability to share  service and resource across several machines arround the world. Informatica is a ETL product, known as Informatica Power Center consists of 3 main components.

informatica online training from hyderabad-india

1)Informatica Power Center Client Tools,
2)Informatica Power Center Repository,
3)Informatica Power Center Server: 

1)Informatica Power Center Client Tools: These are the development tools installed  at developer end. It contain 5 parts in development.

informatica online training course

a) Designer
b) Workflow Manager
c) Workflow Monitor
d) Repository Manager
e) Metadata Reporter

Designer:          Define transformation process, known as mapping.

Workflow Manager:  Define run-time properties for a mapping, known as sessions,

Workflow Monitor:  Monitor execution of sessions,

Repository Manager: Manage repository, useful for administrators

Metadata Reporter:  Report Metadata

2)Informatica Power Center Repository: Repository is the backend of Informatica tools. It is a data inventory where all the data related to mappings, sources, targets etc.

3)Informatica Power Center Server: All the executions will take place in Server. Server makes physical connections to sources/ targets, fetches data, applies the transformations mentioned in the mapping and loads the data in the target system.

Informatica Online Training

1).Introduction to Data Warehousing

  • What is Data warehouse?
  • Components of Data warehouse
  • Decision support systems
  • ODS(Operational Data Store)
  • Difference between ODS and DATAWAREHOUSE
  • OLTP Systems
  • Data Mart
  • Difference between Data warehouse and Data Mart
  • Difference between Data warehouse and ODS, OLTP
  • Data warehousing for OLTP systems
  • Dependent Data warehouse
  • Independent Data warehouse
  • Meta data and Data Mining
  • Data cleansing

2). Database Design and Data Modelling

  • Introduction to Data Modelling
  • What is the use of data modelling in Data warehousing?
  • ER Model for transactional processing
  • Entities and Attributes
  • Schema
  • Star Schema
  • Snowflake Schema
  • Snowflake Schema(hybrid schema or galaxy schema)
  • Fact Table
  • Dimension Tables
  • Multi dimension Tables
  • Granularity for the Data warehousing
  • Grain warehousing Tools consideration

Tools Consideration:

3).ERwin (Data Modelling Tool)

  • Introduction to ERwin
  • Usage of ERwin
  • Physical and Logical Model
  • Creation of Table
  • Forward Engineering
  • Reverse Engineering
  • Complete compare
  • Subject areas
  • Relationships
  • Domains
  • Demoralization
  • Data Modelling report generation
  • HTML report
  • RTF report
  • Text report
  • Creating user defined data types
  • Integrating Tables from different users

4).Informatica 8.6

  • Introduction of Informatica power centre
  • ETL Architecture
  • Data source
  • Data targets
  • Meta data
  • Repository
  • Client components
  • Server components

5).Informatica installation

  • System Requirements
  • Creating Domain
  • Creating Node
  • Configuring Domain With Web Server
  • Assigning Informatica services with Account

6).Informatica Power Centre Web Administration Console

  • Creating integrated services
  • Creating Informatica Repository Services

7).Informatica Repository Manager

  • Creating the workspace(folder)
  • Creating the users
  • Changing the user password
  • Creating users groups
  • Giving privileges to the users, user groups and folder

8).Informatica Designer

  • Connecting to the designer
  • Components of the designer
  • Creating DSN(data source name)
  • Source, Database
  • Warehouse Designer
  • Accessing the source, definitions to the designer
  • Creating the target Tables using warehouse designer
  • Generating target Table to database
  • Transformations between source and target Tables
  • Mapping Designer
  • Mapping between the source and target Tables

9).Types of Transformations:

  • Source qualifier
  • Aggregator
  • Filter
  • Expression
  • Stored Procedure
  • Lookup
  • Sorter
  • Joiner
  • Router
  • Xml source qualifier
  • Update strategy
  • Normaliser
  • Ranking
  • Sequencer Generator
  • Transaction control
  • Union
  • Custom
  • Cubes and Dimensions(creating star schema)
  • Slowly Changing Dimensions(SCD) Mapplets
  • Reusable transformations Debugger
  • Working with mapping using Debugger
  • Data Profiling
  • Variable and Parameters
  • New Features in power centre 7.1

10).Workflow Manager:

  • Components of workflow manager

11).Types of tasks:

  • Session
  • Assigning connection values to the sessions
  • Command
  • Creating workflow
  • Scheduling the workflow
  • Assigning server to workflow
  • Workflow monitor
  • E-mail
  • Session logs
  • Workflow logs

Training Enquiry

If you are unable to reach our contact number, Please fill the above Enquiry Form, otherwise send an email to for quick response.