Informatica 9.6.1 Online Training

Course Duration : 30 Hrs

Informatica Course Content

BASICS OF DATA WAREHOUSING
CHAPTER 1: INTRODUCTION TO DATA WAREHOUSING

• Data warehouse concept
• Differences between Online Transaction Processing and data warehouse
• Types of Data Warehouse
• Data warehouse Architecture
• Difference between Data warehouse & Data mart
• Data Warehouse Approaches
• Data Warehouse Components
• Logical & physical Design
• Operational data sources(ODS)

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

• Informatica PowerCenter
• Product Overview
  • PowerCenter Domain
  • Administration Console
  • PowerCenter Repository
  • PowerCenter Client
  • Repository Service
  • INTEGRATION SERVICE
  • WEB SERVICES HUB

CHAPTER 2: REPOSITORY MANAGER

• Adding a Repository to the Navigator
• Configuring a Domain Connection
• Connecting to a Repository
• Viewing Object Dependencies
• Validating Multiple Objects
• Comparing Repository Objects
• Working with Folders

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

• Push down Optimization Technique
• Unit Testing
• Version Control
• Constraint Based Load Ordering
• Target Load Plan Order