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

Contact Us

Tel: +91-8897400222
USA: +1-512-800-7568
EMAIL: info@mentorsinn.com

Testimonials

"The Informatica training was pretty good, and though I was the only one in the online session the class was very much interactive, it was a very good experience, and I am also looking forward to take more trainings from Mentors Inn on other technologies as and when required for me." - Pradeep (Informatica)