ETL refers to extract, transform, load. Informatica is the best etl tool and it is leader in data integration and data quality services. Informatica is an easy to use tool. Informatica allows you to load data into a centralized location, such as a datamart or data warehouse. Informatica can extract data from multiple heterogeneous sources, transforming them as per business requirement and loading to target tables. Informatica is the highest ratio of successful deployments in the industry. Informatica is very easy to get training and tool availability has made easy resource availability for software industry.

Informatica Online Training Course Content

What you will learn

• Ab Initio Server Hardware
• Ab Initio Installation
• Ab Initio Data Profiles
• Ab Initio File Systems and Heterogeneous Database Systems
• Ab Initio Data Integration Design Specifications
• Ab Initio Application Graphs
• Ab Initio Application Test Plan
• Ab Initio Graph Development Standards Checklist
• Ab Initio Lifecycle Migration
• Ab Initio Application Operations

Introduction to Data warehousing

• What is Data warehousing?
• Who needs Data warehouse?
• Why Data warehouse is required?
• Types of Systems
  • (i) OLTP
  • (ii) DSS

• Maintenance of Data warehouse
• Data warehousing Life Cycle
• Data warehousing Testing Life Cycle

Data warehousing Architecture

• Source
• Integration Layer
• Staging Area
• Targets
• Analysis & Reporting
• ODS

Data Modeling

• Introduction
• Different phases of Modeling

Multi Dimensional Modeling

• What is a Dimension?
• What are Facts?
• Multi Dimensional Model
• Hierarchies
• OLAP
• MOLAP
• ROLAP
  
• HOLAP
• Cubes and its Functions
• Star Schema
• Fact Table
• Dimensional Tables
• Snow flake Schema
• Factless Fact Table
• Confirmed Dimensions

Informatica 8.6

Introduction to Informatica

• Overview
• Basic Definitions
• Informatica Products
• Informatica Architecture
• Tools and their roles
• Folders - Sub Folders

Informatica Designer - Introduction

• Introduction to designer
• Designer interfaces
• Designer tools
• Defining Sources
  • (i) Database as a source
  • (ii) Flat Files sources
• Defining Targets
  • (i) Importing from database
  • (ii) Creating a new target
  • (iii) 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 (v) Event Wait & Event Raise
• Setting properties of Session Task
• Creating Workflow
• Starting Workflow
• Monitoring Workflow

Informatica Advanced Features

• Incremental Aggregation
• Mapping Analyst for Excel (MAE)
• Push-down Optimization
• Mapplet Implementation
• Target Load Plan
• Constraint Based Loading
• Mapping Parameters
• Mapping Variables
• Session Parameters
• Link Conditions
• Meta Data Backup & Restore
• Copying Repository
• Deleting Repository Contents



We are providing Informatica Online Training in Ameerpet Hyderabad. We are one of best Institute to provide Best High Quality Informatica online training all over India. If you are staying in Hyderabad, Bangalore, Chennai, Pune, Delhi, USA, UK, Australia, Singapore etc. and unable to attend regular class room training programs then contact our training institute for information on online training. For more details on Informatica Online Training please call to 9290971883, / 9247461324, or drop a mail to revanthonlinetraining@gmail.com

Informatica online training institute address : B1, 3rd Floor, Eureka Court, Near Image Hospital, Ameerpet, Hyderabad, India