Informatica Online Training
Informatica Online Training
Informatica Online Training
Informatica Online Training Course Content :
Informatica Power Center
- Basic Concepts of Informatica
- Overview Basic Definitions
- Informatica Products, Architecture
- Tools and their Roles
- Power Center Vs Power Mart
- Understanding Informatica Server Configuration
Informatica Designer
- Basic Concepts
- Using the Designer
- Working with Sources
- Working with Flat Files, Targets
- Mappings, Transformations, Mapplets
- Working with Debugger
- Implementing Type 1, Type2, Type 3 Mappings
- Loading the data into different fact tables
Working with Transformations
- Aggregator Transformation
- XML Transformation
- Expression, Look up Transformation
- Rank, Router, Filter, Sequence Generator
- Sorter Transformation
- Source Qualifier Transformation
- Stored Procedure Transformation
- Transaction Control Transformation
- Joiner, Union Transformation
- Java Transformation
- SQL Transformation
- XML Source Qualifier
- Update Strategy Transformation
- Mapplet Input Transformation
- Mapplet Output Transformation
- Connected Vs Unconnected Transformations
Creating Work flows
- Understanding the server Architecture
- Working with Workflows
- Working with Tasks Assignment, Command, Decision, Control, Event Raise Event Wait, Timer , Email, Session Task
- Working with Worklets
- Working with Sessions
- Understanding Commit Points
- Understanding Commit Points
- Monitoring Workflows
- Session Parameters
- Parameter files
- Using Incremental Aggregation
Data Warehousing Basic Concepts
- Data Warehouse Definition,
- Reasons for using, uses
- Characteristics of DWH
- OLTP Vs OLAP Databases
Implementation Methodology
- Kimball Methodology
- Inmon Methodology
Types of Loads
- First Time Load
- Full Load
- Incremental Load
Data Marts and Star Schema Design
- Definition of Star Schema
- Design of Dimension and Facts
- Snow Flake Star Schema
- Slowly Changing Dimensions
- Non Additive Facts
- Conformed Dimensions