Call Us: +91-9000011489

Register for Free Demo

Data Warehousing Concepts:

  • What is Data warehousing?
  • Ralf Kimbol Definition
  • Bill Inmon Definition
  • Types of Systems
  • OLTP
  • OLAP
  • Difference Between OLTP, OLAP
  • Drawbacks of OLTP
  • Data warehousing Project Life Cycle
  • Data Warehousing Project Implementation Approaches

Data warehousing Architecture:

  • Source
  • Staging Area
  • Targets
  • Data Marts
  • ODS
  • EDW

Data Modeling:

  • Conceptual Data Modeling
  • Logical Data Modeling
  • Physical Data Modeling

Dimensional Modeling:

  • What is a Dimension?
  • Types of Dimensions
  • What are Facts?
  • Types  of Facts
  • Cubes
  • Hierarchies
  • OLAP Types (MOLAP,ROLAP,HOLAP)
  • Star Schema
  • Snow Flake Schema

Informatica 9x:

  • Installation/Configuration
  • Informatica Architecture
  • Tools and their roles
  • Repository Service
  • Integration Service
  • DTM Process
  • Informatica Administration Console
  • Environment Setup
  • Differences between 7x, 8x & 9x

Designer:

  • Designer tools
  • Defining Sources
    • Database as a source
    • Flat Files sources
    • XML Sources
  • Defining Targets
    • Importing from database
    • Creating a new target
  • ETL Process in Informatica
    • Source Analyzer
    • Target Designer
    • Mapping Designer
    • Task Developer
    • Workflow Designer
  • Transformations (Active, Passive)
  • Transformations (Connected/Unconnected)
  • Cache
  • Source Qualifier
    • SQL Override
    • Filtering Data
    • Sorting Data
    • Joining Sources
  • Filter
  • Expression
    • Data Cleansing
    • Data Scrubbing
  • Sorter
  • Sequence Generator
    • Replacing Missing Values
  • Rank
  • Aggregator
    • Incremental Aggregation
  • Router
    • Diff Between Router/Filter
  • Joiner
  • Union
  • Lookup
    • Connected
    • Un Connected
    • Cache
  • Stored Procedure
    • Connected
    • Un Connected
  • Update Strategy
  • Transaction Control
  • Normalizer
  • SQL
  • XML

Workflow Manager

  • Relational Connections
  • Re Usable Tasks
    • Session
    • Command
    • E-Mail
  • Non Re Usable Tasks
    • Session
    • Command
    • E-Mail
    • Event Raise
    • Event Wait
    • Decision
    • Timer
    • Control
    • Assignment
    • Link
  • Session properties
  • Creating Workflow
  • Starting Workflow
  • Monitoring Workflow

Advanced Features

  • Constraint Based Loading
  • Target Load Plan
  • Mapplet  Creation & Implementation
  • Mapping Parameters
  • Mapping Variables
  • Session Parameters
  • Flat Files
    • Fixed Width
    • Delimited
    • File Repository
  • Business Components
  • User Defined Functions
  • Debugger
  • Version Control
  • Push Down Optimization
  • Performance Tuning

Informatica Administration Console:

  • Creating Repository Service
  • Creating Integration Service
  • Creating Users
  • Creating Groups
  • Creating Roles
  • Assigning Users to Groups
  • Assigning Roles to Groups