Informatica course for beginners by Gloedge Technologies Pvt Ltd

INFORMATICA 9.6
Duration: 40 hours

Pre Requisite: Oracle SQL & PL/SQL.
_______________________________________________________________
COURSE CONTENTS:

Introduction to Informatica as an ETL tool
Informatica Architecture
Installation & Creating Domain & Repository
Administration Activities

Basic Definitions
Informatica Tools and their roles
Designer
Introduction to designer tools
Mapping designer
Mapplet designer

Transformation Developer
Source Analyzer
Warehouse designer
Customizing designer default Options and using Business names

Working with sources
Working with relational sources
Working with flat file sources

Importing a fixed width and a delimited flat file
Importing COBOL Sources
Working with targets
Creating Reusable transformations
Promoting a standard transformation
Creating instances of Reusable transformations

Adding Reusable transformations to mappings
Modifying a Reusable transformation
Reverting to original reusable transformation
Understanding the various transformations

Source Qualifier Transformation
Aggregate transformation
Expression transformation
Filter transformation

Joiner transformation
Lookup transformation
Normalizer transformation
Update Strategy transformation
Rank transformation

Sequence Generator transformation
Sorter Transformation
Mapplets
Overview
Mapplet Components
Mapplet input
Mapplet Output
Developing a Mapplet
Working with Mapplets
Using Mapplets in mappings

Workflow Manager
Understanding the Server Architecture
Configuring and Using the Workflow Manager
Working with Workflows,
Tasks and Worklets

Working with Sessions, Sources and targets
Log files,
Session Parameters,
Scheduling
Sending Email, FTP,
Incremental aggregation
Session caches,
Performance Tuning

UNIQUE FEATURES
Parameter file creations
Unix basic commands
Real Time senarios