Day1

Introduction to DWH OLAP/OLTP Relational/Dimensional model/Fact/Dimension tables Normalization Datawarehouse/Data mart Bill Inmon vs. Ralph Kimball Introduction to ETL and Business Intelligence Data movement Process Introductions to various ETL Tools Sample mapping to show what exactly is ETL Datawarehouse Real time Projects overview Star schema/snow flake Introduction to Informatica Overview of Informatica products Informatica Architecture Q & A

Day2

Informatica components introduction
Designer,Workflow Manager, Workflow Monitor, Repository Manager, Admin console
Creating a user/ permissions to user and Creating a Folder
Informatica 7.1.1 and 8X differences
Overview of Informatica Designer components
Source Analyzer , Target Designer, Transformation Developer,
Mapplet Designer,

Mapping Designer
Q & A

Day3

Creating ODBC connection
Working with relational Sources
Working with Flat Files
Direct and in-direct methods for Flat file sources
Delimiters in Flat files
Import a relational sources and flat files sources
Source Directory for flat file sources
Targets
Working with Relational Targets
Working with Flat file Targets
Defining Delimters in Targets
Date values handling in Flat files
Target Directory where the target files are placed
Q & A

Day4

Introduction to Transformations
Input/output/variable ports in transformations
Source Qualifier
Filter transformation
Sorter Transformation
Expression Transformation
Router Transformation
Joiner Transformation
Performance tuning with each of the transformations
Real time scenarios with each of the transformations
Q & A

Day5

Union transformation
connected /un connected Lookup Transformation
Rank Transformation
Aggregator transformation
Update strategy Transformation
Sequence Generator Transformation
Normalizer transformation
Mapplet / Mappings / Debugger
Input / output / variable ports in source / target and transformations.
Target Load Plan option in informatica
Q & A

Day6

Informatica Workflow manager components
Creating sessions for mapping
Creating a Worlet/Workflow for the mapping
Creating parameter files
Creating different task like Command task, timer, Decision task, Event raise
Creating connections for source /Targets in the workflow manager
Q & A

Day7

Validating and refreshing the workflow after mapping changes.
Batch runs in informatica.
Sequential and concurrent workflows in informatica.
Commit intervals/Recovery option for Data Loads
Versioning /partitions in informatica
Understanding Jobs and Scheduler in informatica.
Q & A

Day8

Working with Workflow Monitor/Admin console
Analyzing the Session log/Workflow Log
Understanding the server directories/Path for target /source/lookup directories.
Understanding the integration service and repository services.
Understanding the importance of admin console.
Q & A

Day9

Understanding the Migration of real time code from dev to test and then to production
Starting and stopping the informatica services.
Difference between windows and Unix servers.
Performance tuning in informatica
Q & A

Day10

Basic SQL/PLSQL
Basic UNIX
Project Assignment
Will explain approach for the Assignment project.
Explain the script used to populate the fact /dimensions
Comparing the OLAP/OLTP with the projects for better understanding
Q & A

Day11

Complete understanding of the real time projects.
The project handling in real time environment,
Suggestions in Resume preparations.
Project Assignment, Discussion if any pending issues.
Interview Preparation
Will show some real time mappings for better understanding.
Will go through the complete mapping explaining the logic.
Pending topics which are left will be taken over in this sessions.
Q & A

Day12

Complete end to end discussion on project in Day 10
Q&A on informatica topics which you have questions on.

FAQ's

Some FAQs related to Informatica Training
1) Where is the Location of training?
This training we have both online and class room for Online students we will be sharing live Virtual class room, , using our Web Conferencing software. The participants will be able to get their queries answered, Training is held on weekends
2) How about Audio?
You will listen Audio of the instructor using Web Conferencing Software.
3) What are training requirements?
A good quality headphone & microphone to listen & speak to the trainer is must. You can also connect to conference bu Using phone
4) What will be the timings of training?
Pacific Standard Time (PST) – 2:00 PM
5) What is the cost of the training course?
Informatica Training from Basic to Advanced Including Projects for (12 Sessions)
6) During training, will we have access to the environment to practice?
Yes, you will be able to practice during the weekdays as you will be given access to our remote servers.
7) How much of the class will be practical?
First half will be theroy and second half will be Practicals
8) Would we be provided with learning material?
Yes, We will provide training presentations, training material and exercises for practical's