Course #: 12010e - Informatica Datawarehousing

Introduction and Architecture

    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

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

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

  

Recommended Prerequisites:

• There are no mandatory prerequisites. Work experience in IT services is recommended.