[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]