Data Warehousing Concepts

  • Dataware housing (what is Dataware housing /Why Dataware housing/How Dataware housing)
  • Slowly Changing Dimensions (SCD1, SCD2, SCD3)
  • Metadata
  • Dimentinal Table
  • Types Of Dim Tables
  • Fact Table
  • Types of Fact Tables
  • OLTP (OnLine Transaction Processing)
  • OLAP (Online Analysis And Processing)
  • OLTP Vs OLAP
  • Advantages of OLAP
  • Different Methodologies of DW

Introduction to Informatica

  • Basic Definitions
  • Informatica Products
  • Informatica Architecture
  • Tools and their roles
  • Folders -sub Folders
  • Introduction to designer

Informatica Designer -Introduction

  • Designer interfaces
  • Designer tools
  • Defining Sources
  • (i) Database as a source
  • (ii) Flat Flies sources
  • Defining Targets
  • Importing from database
  • Creating a new target
  • Creating target database objects
  • Mapping Introduction

Informatica Designer

  • Source Qualifier
  • Ports
  • Mapping -Table to Table
  • > Mapping flat File to Table
  • Connected/Unconnected Transformations
  • Active and Passive Transformation
  • Source Qualifier Transformation
  • SQl Override-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 & Unconnected)
  • Union Transformation
  • Implementing Type-I, Type-II, Type-III
  • Mappings
  • Workflow Introduction

Informatica - workflow Manager Task

  • Workflow tools
  • Connections
  • Defining tasks
  • (i) Command Task
  • (ii) Email Task
  • (iii) Session Task
  • (iv) Link Conditions
  • Setting Properties of Session Task
  • Creating Workflow
  • Starting Workflow
  • Monitoring Workflow
  • Incremental Aggregation

Informatica Advanced Features

  • Mapplet Implementation
  • Target Load Plan
  • Constraint based Loading
  • Mapping Parameters
  • Mapping Variables

Quick Form