Monday, February 4, 2013

Informatica online training @ monstercourses


Course Name          :  Informatica Online Training
Course Duration  : 30 Hours

Introduction to Datawarehousing Informatica training
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