Informatica 10 Online Training

• 1.1 Architecture and Software Overview
• 1.2 ETL and ELT Architecture Overview
• 1.3 Partitioning and Parallelism Introduction
• 1.4 PowerCenter Services RAM Utilization
• 1.5 Differences Between 32 bit and 64 bit

Client Software Overview

• 2.1 Introduction to Designer Interface
• 2.2 Introduction to Workflow Manager Interface
• 2.3 Introduction to Workflow Monitor
• 2.4 Introduction to Repository Manager
• 2.5 Nature of ODBC in the Designer
• 2.6 Software Demonstration

Source Object Definitions

• 3.1 Flat File Sources
• 3.2 Relational Sources
• 3.3 Data Previewer
• 3.4 Metadata Extensions
• 3.5 LAB: Import a Source

Target Object Definitions

• 4.1 Target Definitions
• 4.2 Target Properties
• 4.3 Flat File Targets
• 4.4 Relational Targets
• 4.5 LAB: Import a Target

Informatica Mappings

• 5.1 Defining a Data Flow Diagram
• 5.2 Transformation Objects and Views
• 5.3 Source Definition and Source Qualifier
• 5.4 Pre-SQL and Post-SQL Rules
• 5.5 Expression Transformation
• 5.6 Informatica Functions
• 5.7 Variable Ports
• 5.8 Data Types
• 5.9 Mapping Validation
• 5.10 LAB: Create a Working Mapping

Informatica Workflows

• 6.1 Workflow Tools
• 6.2 Workflow Structure
• 6.3 Workflow Connections
• 6.4 Workflow Tasks
• 6.5 Workflow Design Process
• 6.6 Workflow Properties
• 6.7 Workflow Links
• 6.8 Session Tasks
• 6.9 LAB: Configure a Workflow and Session

Monitoring Workflows

• 7.1 Workflow Monitor Views
• 7.2 Monitoring a Server
• 7.3 Actions Initiated from the Workflow Monitor
• 7.4 Filtering Views
• 7.5 Truncating Monitor Logs
• 7.6 Stop Versus Abort
• 7.7 LAB: Run and Monitor the Workflow
• 7.8 LAB: Demonstration of Designer Features

Debugger

• 8.1 Debugger Features
• 8.2 Debugger Windows and Indicators
• 8.3 Debugger Best Practices
• 8.4 LAB: Debug the Mapping

Filter Transformation

• 9.1 Filter Functionality
• 9.2 Filter Properties
• 9.3 Filter Versus DB Where Clause
• 9.4 LAB: Create a Filter Transformation, Run Workflow

Sorter Transformation

• 10.1 Sorter Functionality
• 10.2 Sorter Properties
• 10.3 Sorter Versus Database Order by Clause

Aggregator Transformation

• 11.1 Aggregator Transformation
• 11.2 Aggregator Expressions and Functions
• 11.3 Using Unsorted and Sorted Data
• 11.4 Data Flow Rules
• 11.5 Aggregator Versus Database Group By

Joiner Transformation

• 12.1 Homogeneous and Heterogeneous Joins
• 12.2 Joiner Conditions and Properties
• 12.3 Joiner Usage
• 12.4 Nested Joins
• 12.5 Joiner Versus Database Join
• 12.6 LAB: Add Sorter, Joiner, and Aggregator

Lookup Transformation

• 13.1 Lookup Principles
• 13.2 Lookup Properties
• 13.3 Lookup Caching
• 13.4 Lookup Versus Database Join
• 13.5 LAB: Create a Basic Lookup

Target Options

• 14.1 Target Properties
• 14.2 WHERE Clause
• 14.3 Constraint-Based Loading
• 14.4 Target SQL Override Best Practices

Update Strategy Transformation

• 15.1 Update Strategy Transformation
• 15.2 Update Strategy Expressions
• 15.3 Update Strategy Best Practices
• 15.4 LAB: Create a Type 2 Dimension Update

Router Transformation

• 16.1 Router Functionality
• 16.2 Router Groups
• 16.3 LAB: Use a Router to Delete Rows
• 16.4 LAB: Data Driven Versus Session Switches

Parameters and Variables

• 17.1 Parameter Scoping
• 17.2 System Variables
• 17.3 Mapping Parameters and Variables
• 17.4 Variable Functions

Unconnected Lookups

• 18.1 Usage and Techniques
• 18.2 Advantages
• 18.3 Functionality
• 18.4 Conditional Lookups
• 18.5 LAB: Create an Unconnected Lookup

Heterogeneous Targets

• 19.1 Heterogeneous Target Types
• 19.2 Target Type Limitations and Conversions
• 19.3 LAB: Build Heterogeneous Targets

Mapplets

• 20.1 Mapplet Designer
• 20.2 Mapplet Advantages
• 20.3 Mapplet Types and Rules
• 20.4 Active and Passive Mapplets
• 20.5 Mapplet Parameters and Variables
• 20.6 Mapplet Designer Best Practices
• 20.7 LAB: Build a Mapplet

Reusable Transformations

• 21.1 Transformation Developer
• 21.2 Rules
• 21.3 Promoting and Copying Transformations
• 21.4 Transformation Developer Best Practices
• 21.5 LAB: Create and Use a Reusable Transformation

Sequence Generator Transformation

• 22.1 Sequence Generator Functionality
• 22.2 Sequence Generator Properties
• 22.3 Sequence Generator Best Practices
• 22.4 LAB: Create a Variable Based Sequence Generator

Error Logging

• 23.1 Setting On and Off
• 23.2 Data Rejects with Error Logging Off
• 23.3 Error Logging to Database Table and Flat File
• 23.4 Source Row Logging
• 23.5 Error Logging Best Practice Architecture

Workflow Configuration

• 24.1 Server Connections
• 24.2 Reusable Workflow Schedules
• 24.3 Reusable Session Configurations
• 24.4 LAB: Create a Sequential Workflow
• 24.5 LAB: Create a Concurrent Workflow

Reusable Tasks

• 25.1 The Command Task
• 25.2 The Email Task
• 25.3 Reusable Task Best Practices

Non-Reusable Tasks

• 26.1 The Decision Task
• 26.2 The Assignment Task
• 26.3 The Timer Task
• 26.4 The Control Task
• 26.5 The Event Wait Task
• 26.6 The Event Raise Task
• 26.7 Non-Reusable Tasks Best Practices
• 26.8 LAB: Create Event Wait/Event Raise and Timer
• 26.9 LAB: Create a Control and Assignment Task
• 26.10 LAB: Create a Command Line Task

Worklets

• 27.1 Reusable Worklet
• 27.2 Non-Reusable Worklet
• 27.3 Worklet Best Practices