Informatica Online Training, Informatica 9 Online Training

By Author: monster courses
Total Articles: 116
Comment this article

Monstercourses is the leading and pioneer in job oriented Informatica online training, offering best online training on all IT technologies by industry real time employees on hands on online training

ETL Informatica Online Training, Online Informatica Training

Inspired faculty
Hands on trainers
Material will be provided
Software will be installed
Resume guidance will be given
One free demo will be given before sign up for the course
Affordable price
Quality Informatica online training
Placement assistance will be provided
Experienced trainers
Software will be provided
Online training will be held through goto meeting and WebEx
Live interactive Informatica online training classes

Course Name : Informatica Online Training

Course Duration : 30 Hours

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

Pl visit: http://www.monstercourses.com/informatica

+1 772 777 1557 & +44 702 409 4077, visit: http://www.monstercourses.com/

Monstercourses is having fully qualified and industry experts who can teach quality online training to the students,
Our online training classes include data warehousing, sap, oracle, Microsoft technologies, JAVA. J2ee, core java, testing tools, android etc.

http://www.monstercourses.com/