Informatica 9.6.1 Online Training

BASICS OF DATA WAREHOUSING
CHAPTER 1: INTRODUCTION TO DATA WAREHOUSING

CHAPTER 2: MODELLING FOR DATA WAREHOUSE

Fact Table
Dimension tables and types
Data Warehouse Schemas: Star schema and Star Query, star flake schema, snow flake schema and Galaxy Schema

INSTALLATION of INFORMATICA and CONFIGURATION
CHAPTER 1: TOOL KNOWLEDGE

CHAPTER 2: REPOSITORY MANAGER

CHAPTER 3: POWERCENTER DESIGNER

Source Analyzer
- Working with Relational Sources
- Working with Flat Files
Target Designer
Mappings
Transformations
- Working with Ports
- Using Default Values for Ports
- User-Defined Default Values
Tracing Levels
Basic First Mapping
Expression Transformation
Filter Transformation
Router Transformation
Union Transformation
Sorter Transformation
Rank Transformation
Aggregator Transformation
Joiner Transformation
Source Qualifier
Lookup Transformation
- Lookup Types
- Lookup Transformation Components
- Connected Lookup Transformation
- Unconnected Lookup Transformation
- Lookup Cache Types: Dynamic, Static, Persistent, Shared
Update Strategy
Dynamic Lookup Cache Use
Lookup Query
Lookup and Update Strategy Examples
Stored Procedure Transformation
- Connected Stored Procedure Transformation
- Unconnected Stored Procedure Transformation
Sequence Generator Transformation
SCD Type 1 and Type 2 with real time examples
Mapplets: Mapplet Input and Mapplet Output Transformations
Normalizer Transformation
XML Sources Import and usage
Mapping Parameters and Variables
Parameter File
Indirect Flat File Loading

CHAPTER 4: WORKFLOW MANAGER

Working with Workflows
- Assigning an Integration Service
- Working with Links
- Workflow Variables
- Session Parameters
Working with Tasks
- Session Task
- Email Task
- Command Task
- Working with Event Tasks
- Timer Task
- Decision Task
- Control Task
- Assignment Task
Schedulers
Worklets
Session Properties
Workflow Properties

CHAPTER 5: ADVANCED TOPICS

Online Training Enquiry Form