linkedin-tutornexus facebook-tutornexus tuornexus-twitter
Online Training Registration
online software trainer jobs

Recent Training Venues

TutorNexus has recently trained for clients in the following US cities:

  • New York, New York
  • Los Angeles, California
  • Chicago, Illinois
  • Houston, Texas
  • Philadelphia, Pennsylvania
  • Phoenix, Arizona
  • San Diego, California
  • Dallas, Texas
  • San Antonio, Texas
  • Detroit, Michigan
  • San Jose, California
  • Indianapolis, Indiana
  • San Francisco, California
  • Jacksonville, Florida
  • Columbus, Ohio
  • Austin, Texas
  • Memphis, Tennessee
  • Baltimore, Maryland
  • Milwaukee, Wisconsin
  • Boston, Massachusetts
  • Charlotte, North Carolina
  • El Paso, Texas
  • Washington, D.C.
  • Seattle, Washington
  • Fort Worth, Texas
  • Denver, Colorado
  • Nashville-Davidson, Tennessee
  • Portland, Oregon
  • Oklahoma City, Oklahoma
  • Las Vegas, Nevada
In INDIA cities
  • Hyderabad
  • Vizag
  • Delhi
  • Mumbai
  • Bengaluru
  • Pune
  • Chennai
  • Kolkata
  • Jalandhar
  • Vijayawada
  • Guntur
  • Tirupati
  • Nellore
Informatica Online Training

Online Informatica Training :

TutorNexus global online training center provides courses on site, over the internet, and has best online tutors located around the world. Informatica Online training course made easy through TutorNexus.com by his best available experienced online tutors. Instructor led classes’ offer intensive, role-based training with fully equipped world class infrastructure and bring the Informatica online training best experience.

TutorNexus provide an opportunity to interact with the online tutors and peers, further enhance the Informatica online training experience by sharing the real time tips, tricks and best Industry practices. We can arrange the Informatica online training demo at your convenience and where you have an opportunity to interact with the tutor directly and decide how the Informatica online training course best suits your career needs.

Informatica Online training course details:

Data Warehousing Concepts:

Introduction to Data Warehousing

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

Database Design and Data Modeling

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

Tools Consideration:

ERwin (Data Modeling Tool)

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

Informatica 8.6

Introduction of Informatica power center
ETL Architecture
Data source
Data targets
Meta data
Server components
Client components

Informatica installation

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

Informatica Power Center Web Administration Console

Creating Informatica Repository Services
Creating integrated services

Informatica Repository Manager

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

Informatica Designer

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

Types of Transformations:

Source qualifier
Stored Procedure
Xml source qualifier
Update strategy
Sequencer Generator
Transaction control
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

Workflow Manager:

Components of workflow manager

Types of tasks:

Creating workflow
Scheduling the workflow
Creating connections
Assigning connection values to the sessions
Assigning server to workflow
Workflow monitor
Session logs
Workflow logs

Know About Informatica MDM Hub Online Training Courses.

 Featured Courses
 Quick Enquiry

SAS Online Training
Core Java Training
J2EE Online Training
QTP Online Training
Shell Scripting Training
OBIEE online Training
Data Stage Online Training
BODI Online Training
TutorNexus Focuses on You!

TutorNexus ’s courses are taught for private groups of 3 or more people at your site or online anywhere worldwide.

Don't settle for a "one size fits all" public class!Have TutorNexus deliver exactly the training you want, privately at your site or online, for less than the cost of a public class.

For pricing and to learn more, please contact us via information request form or phone, or email us at info@tutornexus.com today.

Recent Training Venues

TutorNexus has recently trained for clients in the following AUS cities:

  • Adelaide
  • Brisbane
  • Byron Bay
  • Cairns
  • Canberra
  • Capricorn Coast
  • Fraser Island
  • Geelong
  • Gold Coast
  • Hervey Coast
  • Melbourne
  • Newcastle
  • Northern Territory
  • Perth
  • Sunshine Coast
  • Sports
  • Status
  • Sydney
  • Tasmania
  • Townsville
  • Whitsundays

  • Airdrie
  • Brooks
  • Calgary
  • Camrose
  • Cold Lake
  • Edmonton
  • Fort Saskatchewan
  • Grande Prairie
  • Lacombe
  • Leduc
  • Lethbridge
  • Lloydminster
  • Medicine Hat
  • Quebec
  • Red Deer
  • Spruce Grove
  • St. Albert
  • Wetaskiwin


Online Software Training   SAS Online Training SAP MM Online Training WinRunner Training Online WPF WCF Training
Informatica Online Training    SAS BI Online Training SAP BW/BI Online Training SEO Online Training Cognos Business Intelligence Training
Data Stage Online Training     SAS CDM Online Training  SAP Business Objects Training  Web Designing Online Training SAP CRM Online Training
BO XI Online Training      SAP ABAP Online Training Oracle 11g Online Training Perl Scripting Training QTP Online Training
BODI Online Training       SAP Basis Online Training Oracle DBA Training  Shell Scripting Training SharePoint Training Online
Teradata Online Training  Web Dynpro ABAP Training  Core Java Training ASP.NET Training Online Microsoft Business
OBIEE online Training SAP FICO Online Training   Advance Java Training Biz Server Online Training SAP HR Online Training
Microstrategy Online Training SAP APO Online Training  J2EE Online Training  C Sharp Online Training LoadRunner Online Training
Java® and all Java-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries. JBoss® and Hibernate® are registered trademarks of Red Hat, Inc.  TutorNexus has no affiliation with Red Hat, Inc. and no courses offered by TutorNexus are endorsed by Red Hat, Inc. in any way. WebSphere® is a registered trademark of IBM. TutorNexus has no affiliation with IBM. Sap is the registered trade mark of SAP AG and no courses offered by TutorNexus are endorsed by SAP AG. Oracle is the registered trademark of Oracle Inc, and no courses offered by TutorNexus are endorsed by Oracle Inc