Informatica Online Training

informatica online training

 Informatica 10 Online Training

Course Duration  : 30 Hours

Introduction to Datawarehousing Informatica training Online

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

Fill up quick inquiry form to get more details on Informatica online training