Online Solvers ( SINCE 2005 ) : Call US: +1 339 368 6489 (USA) | +91 - 880 138 6489 (INDIA)

Pioneer In Online Training.
Online Training By Real Time Industry Experts with Professionalism and Commitment.

Informatica Online Training


Informatica Course Content:
Data warehouse basics * OLTP System * Data warehouse * Different Definitions of data warehouse * Difference between OPERATIONAL DS AND DWH * Types of ETL * Data Extraction * Data Transformation * Data Merging * Data Loading * Types of Data loading * Data Aggregation * Data warehouse Approaches * Top down approach and Bottom up approach * DW Life cycle * DW-database design * Star schema and Snow flake schema * Facts and dimensions * Granuality * Types of Dimensions * Types of fact table * Types of Olap Informatica Power Center 8.6 Power center Administration * Informatica Power center architecture * Power center components * ETL Plan * Power center Clients * Designer * Workflow manager * Work Flow monitor * Workflow manager * Repository manager * Power center repository * Administrative tool * Repository services * Integration services * Power center domain * Application services * Concept of nodes and grid * Service manager * Power center administration console Repository Administration * Creating Repository Users and Groups . * Connecting to the Repository. * Creating a Group * Assigning Privileges to a Group. * Creating a User * Creating a Folder * Folder Permissions * Creating Folders Using the designer * Creating Source Tables. * Creating Target Definitions. * Creating Target Tables * Creating a Pass-Through Mapping * Creating source definitions * Creating a Mapping * Connecting Transformations Transformation Creation * Using Transformations * Creating a Mapping with Aggregate Values * Active and passive transformations * Creating an Aggregator Transformation * Creating an Expression Transformation * Creating a Lookup Transformation * Connecting the Target * Designer Tips. * Using the Overview Window * Arranging Transformations * Creating the Session * Creating the Workflow * Creating a Mapping with Fact and Dimension Tables * Creating a Filter Transformation * Creating a Sequence Generator Transformation * Creating a Stored Procedure Transformation * Completing the Mapping * Creating a Workflow * Creating a Link Condition. * Running the Workflow XML sources and Monitoring loads * Using XML Files * Creating the XML Source * Importing the XML Source * Editing the XML Definition * Creating the Target * Creating a Mapping with XML Sources and Targets * Creating an Expression Transformation * Creating Router Transformations * Completing the Mapping * Creating a Workflow * How to monitor loads * Use of Workflow monitor Using the workflow manager * Connecting Transformations * Creating Sessions and Workflows * Configuring Database Connections in the Workflow Manager * Creating a Reusable Session * Creating a Workflow * Running and Monitoring Workflows * Opening the Workflow Monitor * Running the Workflow Workflow Tasks * Session * Assignment task * Link task * Event raise task * Event wait task * Timer task * Post session and Pre-session commands * Session recovery * Commit points * Creation of Parameter file * Mapping and session parameter Performance tuning in ETL * Various optimization technique * Pushdown optimization * Incremental aggregation


Copyright 2010 Online Solvers. All Rights Reserved