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]