Business Intelligence Training : Informatica Developer

Informatica Developer

Business Intelligence Training Overview

Working on a ETL Tool like Informatica project can be overwhelming if you don't have a solid grounding in the basics. It's difficult to focus on the goals of the project when you're bogged down by unanswered questions - or don't even know what questions to ask. By arming yourself with knowledge of the concepts and fundamentals, you can hit the ground running. This course provides an overview that gives business and information technology professionals the confidence to dive right into their business intelligence and data warehousing activities and contribute to their success.

What you will learn

Basic concepts of ETL & Informatica
Industry terminology
Critical success factors & risks
Transformations & Mapping Techniques
Data warehousing & business intelligence development processes
Culture, politics & organizations
Best practices
Industry trends

Business Intelligence Audience

This course provides an introduction to those who may be involved in the process of designing and implementing a ETL application or data warehouse. It is also for those who just need to understand what is involved in managing either a business intelligence or data warehouse project.

Business Intelligence Prerequisites

All the participants must be aware of any RDBMS activities along with its application.

Business Intelligence Training Course duration

Five(5) Days Classroom & Lab Session.

Business Intelligence Training Course outline

Day 1 & 2

Introduction Informatica and Architectural Overview

Repository Topics

Repository Server 9.X and Agent
Repository maintenance
Security, repository privileges, and folder permissions
Arch of Informatica 9.X
Tools Information
Domain & Node Config

Source Object Definitions

Source types (RDBMS[Oracle],TEXT,XML)
Source properties

Target Object Definitions

Target types (RDBMS[Oracle],TEXT)
Target properties

Transformation Concepts

Transformation types and views
Transformation features and ports

Mappings

Mapping components
Source Qualifier transformation
Mapping validation
Data flow rules

Session Tasks

Session Task properties
Session components

Workflows

Workflow Tools
Workflow structure and configuration
Workflow Connections
Workflow Tasks
Workflow Design and properties

Workflow Monitoring

Workflow Monitor views
Monitoring a Server
Actions initiated from the Workflow Monitor

Day 2 & 3

Filter transformation

Filter properties

Expression transformation

Expression properties
IN, OUT, Variable Ports

Source Qualifier transformation

Source Filter properties

Router transformation(Multi Targets)

Group properties
Group Based Filters

Joiner transformation

Joiner properties
Homogeneous Sources
Heterogeneous Sources
Performance Issues
Source Qualifier Based Joins

Rank transformation

Rank properties

Sequence Generator transformation

SG properties

Day 4

Aggregator transformation

Aggregation properties

Working with Parameters & Variables

Target Load Plan

Lookup transformation

Lookup principles
Lookup properties
Connected & Un-Connected

Update Strategy transformation

Update Strategy expressions
Smart aggregation
Refresh strategies

Day 5

Working with Session Properties

Creating using Task Developer
Creating using Workflow Designer

Workflow Process Management(WPM)

Concurrent and sequential Workflows

Concurrent Workflows
Sequential Workflows
Stopping, starting, and suspending tasks and workflows

Workflow Objects

Link
Decision
Event Wait
Event Raise
Control
Command
Email
Worklets
Scheduling

Summary & Conclusion

Repository Backup & Restoring