INTRODUCTION AND ARCHITECTURAL OVERVIEW
Introduction to Service Oriented Architecture - What's new in Infa 8 - Informatica 8 architecture - Installation and Configuration - Integration Service: Configuration, Start/Stop, Basic Administration. Repository Service: Configuration, Start/Stop, Basic Administration. - Admin Console: Usage - Properties, Domain / Node Basics

REPOSITORY MANAGEMENT
Repo service – Maintenance - Folder & Security Concepts: Shared/ Non-shared, Group/ User/ Permissions

INFORMATICA TOOLS:
List of tools: Development tools - Explain each tool with its features - Admin tools: Explain each tool with its features.

INFORMATICA OBJECTS: Sources & Targets:
Types of sources/targets - Creation and configuration using Developer - Relational - Flat File (Fixed / De-limited) – XML - Mainframe – VSAM / PowerExchange

TRANSFORMATIONS:
Transformation types - Transformation features - Creation and Basic - configuration - Advanced Properties - Active / Passive difference - Cover all transformations – Cache: Basics, Types, Usage in transformations, Properties. - Run-time properties – Ports: Usage - Parameters and Variables: Usage - Transformation rules -Reusable transformations – rules and how to create - Coding Standards

MAPPING & MAPPLETS:
Creation – Definition - Mapplets – rules and how to create and use – Validation - Coding Standards

TASKS:
Types of tasks - Properties and configuration - Re-usable and non re-usable tasks - Coding Standards.

WORKFLOWS AND WORKLETS:
Creation and configuration, Connections and Links, Worklets, rules and how to create and use, Coding Standards

OTHER CONCEPTS:
Versioning:
What is versioning - How it is available in Informatica - Usage

Deployment:
What is deployment - Deployment groups - Creation and configuration - Label creation and usage - Migration from one environment to another.

Partitioning:
What is partitioning - Dynamic partitioning - Rules of partitioning for each transformation - Partitioning in action

XML/ UDO / Web Services
Basics - Usage and configuration

Repository
Backup and Restoration - Code Pages and Character Sets

DW CONCEPTS

SCD: Types of SCD - Implementing SCD Types using Informatica

Workflow Monitoring
Workflow Monitor views - Monitoring a Server Actions initiated from the Workflow Monitor - Filtering views

Performance Tuning

Bottlenecks - Configuring Properties of Info objects for Performance Tuning - DTM basics - Threads basics

Monitoring:
Monitoring workflows, Different Views

Debugging:
Ways and approach to debug issues - Using Debugger Tool - Test data Load - Different log files generated - How to interpret messages in Log File - Tracing Levels - Query Tuning