ETL Informatica online training, online informatica training, informatica 9 online training

Course Name          : ETL Informatica 9 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 

for full Informatica online training course content, please visit : monstercourses