Informatica online training, Informatica online training from India

By | February 22, 2014

Informatica online training at your home from Monstercourses , high quality Online training , informatica online training by industry experts,Informatica online training by real time experts on hands on online training on real time work environment

Introduction to Datawarehousing Informatica training @ monstercourses

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


·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


·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


·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


·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


·27.1 Reusable Worklet

·27.2 Non-Reusable Worklet

27.3 Worklet Best Practices

Contact for more job oriented IT online training courses