INFORMATICA TRAINING

INFORMATICA 9 ONLINE TRAINING

Informatica is one of the best ETL Tool . Mentors Inn offers a comprehensive portfolio of training on a variety of Informatica solutions. With our expertise in the field of IT training offers you training customized to your needs.

INFORMATICA 9 COURSE CONTENT

DATA WAREHOUSING CONCEPTS

  • Data Warehouse
  • Data Mart
  • OLAP VS OLTP
  • Data Warehouse Architecture (Basic)
  • Dimensional Modeling
  • Star Schema
  • Snowflake Schema
  • Dimension
  • Fact
  • Slowly Changing Dimension
  • Hierarchy
  • Confirmed Dimension
  • Fact less Fact
  • Summary / Aggregations table
  • Change Data capture

E T L INFORMATICA POWER CENTER 9

POWER CENTER COMPONENTS

  • Designer
  • Repository Manager
  • Workflow Manager
  • Workflow Monitor

INFORMATICA CONCEPTS AND OVERVIEW

  • Informatica Architecture.
  • Source Qualifier
  • Target Designer
  • Transformations
  • Mappings
  • Mapplets
  • Sessions
  • Tasks

SOURCES

  • Working with relational Sources
  • Working with Flat Files

TARGETS

  • Working with Relational Targets
  • Working with Flat file Targets

TRANSFORMATIONS

  • Expression Transformation
  • Lookup Transformation
  • Sequence Generator Transformation
  • Filter Transformation
  • Joiner Transformation
  • Sorter Transformation
  • Procedural Transformation
  • Router Transformation
  • Aggregator Transformation
  • Update Strategy Transformation
  • Union Transformation
  • Rank Transformation
  • Transaction Control Transformation
  • Normalizer Transformation
  • Source Qualifier Transformation
  • Stored Procedure Transformation
  • XML Source Qualifier Transformation
  • Debugging Mappings

POWER CENTER TRANSFORMATION LANGUAGE

  • Numeric functions
  • String Functions
  • Date Functions
  • Conversion Functions
  • Cleansing Functions
  • Aggregate Functions
  • User Defined Functions

ADVANCED INFORMATICA CONCEPTS

  • Unconnected lookup Transformation
  • Unconnected Stored Procedure to Create and Drop Index
  • Mapplet and Types of Mapplets
  • Defining Reusable Transformations.
  • User Defined Functions.
  • Tasks And Types of Tasks.
  • Worklet and Types of Worklets.
  • Scheduling Work flow
  • Constraint Based Load Ordering.
  • Target Load Plan
  • Types of Batch Processing
  • Link conditions
  • Mapping Parameters
  • Mapping Variables
  • Defining Session Parameters
  • Session Recovery
  • Difference Between Normal and Bulk Loading.
  • Push Down Optimization.
  • PMCMD Utility
  • PMREP Utility
  • Incremental Aggregation
  • TYPES Of LookUp Caches.
    • Static LookUp Cache
    • Dynamic LookUp Cache
    • Perisistance lookup Cache
    • Shared LookUp Cache

ETL UNIT TESTING

ETL PERFORMANCE TESTING

ETL PERFORMANCE OPTIMIZATION TECHNIQUES

TASK IMPLEMENTATIONS.

  • Command
  • EMAIL
  • Timer
  • Event Wait
  • Event Raise
  • Decision
  • Assignment
  • Control
  • Worklet
  • Session