Call us : (+91) 9177166122

Informatica Online Training Course

Informatica

Data Warehousing Basic Concepts

  • Data Warehouse Definition,
  • Reasons  for using, uses
  • Characteristics of DWH
  • OLTP Vs OLAP Databases

Data Marts and Star Schema Design

  • Design of Dimension and Facts
  • Definition of Star Schema
  • Snow Flake Star Schema
  • Slowly Changing Dimensions
  • Non Additive Facts
  • Conformed Dimensions

Implementation Methodology

  • Kimball Methodology
  • Inmon Methodology

Types of Loads

  • First Time Load
  • Full Load
  • Incremental Load

INFORMATICA  9.6

Informatica Power Center

  • Basic Concepts of Informatica
  • Overview Basic Definitions
  • Informatica Products, Architecture
  • Tools and their Roles
  • Understanding Informatica Server Configuration

Informatica Designer

  • Basic Concepts
  • Using the Designer
  • Working with Sources
  • Working with Flat Files, Targets
  • Mappings, Transformations, Mapplets
  • Working with Debugger
  •  Implementing Type 1, Type2, Type 3 Mappings
  • Loading the data into different fact  tables

Working with Transformations

  • Aggregator Transformation
  • XML Transformation
  • Expression, Look up Transformation
  • Rank, Router, Filter, Sequence Generator
  • Sorter Transformation
  • Source Qualifier Transformation
  • Stored Procedure Transformation
  • Transaction Control Transformation
  • Joiner, Union Transformation
  • Java Transformation
  • SQL Transformation
  • XML Source Qualifier
  • XML Generator
  • XML Parser
  • Update Strategy Transformation
  • Mapplet Input Transformation
  • Mapplet Output Transformation
  • Connected Vs Unconnected Transformations

Creating Work flows

  1. Understanding the server Architecture
  2. Working with Workflows
  3. Working with Tasks like Assignment , Command, Decision Control, Event Raise, Event Wait, Timer , Email, Session Task
  4. Working with Worklets
  5. Working with Sessions
  6. Understanding Commit Points
  7. Monitoring Workflows
  8. Session Parameters
  9. Parameter files
  10. Using Incremental Aggregation

Real-Time Implementation with Informatica

  • Using Incremental Aggregation
  • Incremental Extraction with Mapping Parameters and Variables
  • Session parameters and variables
  • Session and Workflow Properties Reference
  • Configuring Session Caches Lookup, Aggregate, Sort, Joiner Caches
  • Constraint Based Loading
  • Target Load Plans
  • Dynamic Lookup

_____________________________

Pre-Requests For Course:

·  Any Database(SQL)

·  PL/SQL or TSQL (Optional)