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
OLTP vs DATAWAREHOUSE
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
OLAP,ROLAP,MOLA
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?
Schema
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
Domains
Subject areas
Relationships
Demoralization
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
Repository
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 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
Aggregator
Filter
Expression
Stored Procedure
Lookup
Sorter
Joiner
Router
Xml source qualifier
Update strategy
Normalizer
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
Workflow Manager:
Components of workflow manager
Types of tasks:
Session
E-mail
Command
Creating workflow
Scheduling the workflow
Creating connections
Assigning connection values to the sessions
Assigning server to workflow
Workflow monitor
Session logs
Workflow logs
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:
Disclaimer
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