+91 – 88617 28680learning@flexmind.co

Informatica Developer Training

[vc_row][vc_column][vc_btn title=”Request a Demo” color=”success” i_icon_fontawesome=”fa fa-envelope-o” link=”url:http%3A%2F%2Fwww.flexmind.co%2Fcontact%2F%23firstcontentcontainer|title:Informatica%20training|target:%20_blank” add_icon=”true”][vc_facebook type=”button_count”][vc_column_text]

Informatica developer training

Course Details
Duration: 30 Hours

Module 1:-Data warehouse Concepts

  • Data Warehouse
  • Data Mart
  • OLAP VS OLTP
  • Data Warehouse Architecture (Basic)
  • Data Warehouse Architecture (with a Staging Area)
  • Dimensional Modeling
  • Star Schema
  • Snowflake Schema
  • Facts
  • Dimensions
  • Slowly Changing Dimension (All types)
  • Hierarchy
  • Confirmed Dimension
  • Fact less Fact
  • Summary / Aggregations table
  • Change Data capture
  • ETL concepts

Module 2:- Basic SQL Overview

  • DDL Statements
  • DML Statements
  • Joins
  • Sub Query
  • Correlated Sub Query
  • Ordered Analytical functions
  • Views, Materialized views

Module 3:-ETL Informatica Power Center 9.X

  • Power Center Components
  • Designer
  • Repository Manager
  • Workflow Manager
  • Workflow Monitor

Module 4:-Informatica Concepts and Overview 

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

Module 5:- Sources & Targets

  • Working with relational Sources
  • Working with Flat Files
  • Working with Relational Targets
  • Working with Flat file Targets

Module 6:-Transformations

  • Expression
  • Lookup
  • Sequence Generator
  • Filter
  • Joiner
  • Sorter
  • Union
  • Router
  • Aggregator
  • Active and Passive Transformations
  • Update Strategy
  • Data Concatenation
  • Debugging Mappings

Module 7:-Mappings & Mapplets 

  • Mapping Variables & Parameters
  • Working with debugger
  • Working with Mapping Wizards
  • Implementing SCD-1
  • Implementing SCD-2
  • Implementing SCD-3
  • Error Handling in Mapping
  • Debugging of Mapping

Module 8:-Workflow Manager 

  • Server Architecture
  • Workflows, Worklets & Sessions
  • Tasks, Assignments, Events, Command.

Module 9:-Performance Tuning 

Informatica Tuning (Source, target, mapping & Session)

Module 10:- Each topic will be covered with extensive hands on. [/vc_column_text][/vc_column][vc_column][/vc_column][/vc_row]