Informatica Tutorial - Informatica Online Training
3.7 (461 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,727 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Informatica Tutorial - Informatica Online Training to your Wishlist.

Add to Wishlist

Informatica Tutorial - Informatica Online Training

Learn Informatica PC ETL Development tool online with examples.
3.7 (461 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,727 students enrolled
Last updated 3/2017
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 18.5 hours on-demand video
  • 4 Articles
  • 24 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Understand Basic Concepts of Data Warehouse
  • Understand Various ETL Tools in Market and Why to Choose Informatica
  • Idea of Real World ETL Projects
  • Clear Understanding of Informatica Powercenter Architecture and Componenets
  • Use of Informatica Powercenter ETL tool in real time project scenarios
  • Perform Installation of Informatica Powercenter
  • Understand Real Time Client-Server Architecture
  • Understand Informatica ETL Developer Roles and Responsibilities
  • Understand Informatica ETL Admin Roles and Responsibilities
  • Use of various Transformation techniques like • Expression • Lookup –Different types of lookup Caches • Sequence Generator • Filter • Joiner • Sorter • Rank • Router • Aggregator • Source Qualifer • Update Strategy • Normalizer • Union
  • Understand and Implement Slowly Changing Dimensions - • SCD Type1 • SCD Type2 — Date, Flag and Version • SCD Type3
  • Use Workflow Manger in Real time projects for • Creating Reusable tasks • Workflows, Worklets& Sessions • Tasks • Session • Decision task • Control Task • Event wait task • Timer task • Monitoring workflows and debugging errors
  • Able to perform - 1. Indirect Loading 2.Constraint based load ordering 3.Target Load plan 4.Worklet ,Mapplet ,Resuable transformation 5.Migration –XML migration and Folder Copy. 6.Scheduling Workflow 7.Parameter and variables 8.XML Source, Target and Transformations
  • Implement Performance Tunning using Informatica
  • Perform Project - Case Study
  • Interview Questions & Answers
View Curriculum
  • Basic SQL
  • Keen to learn most popular ETL tool in IT market

Informatica Tutorial - Informatica PowerCenter Online Training

If you want to become expert in world's most commonly used ETL tool, you have come to right place. With this tutorial you will know everything you need to know and able to work as Informatica Developer. Start earning minimum $80,000 per year by learning Informatica.

All topics are covered with real time project examples which will give you full confidence to stand as ETL developer.

Course summary -

  • Real World DW Project Example
  • What is ETL?
  • Various ETL Tools In market
  • Informatica Components List
  • Informatica Client-Server Architecture
  • Role of Informatica Admin & Developers
  • Installation & Configuration
  • Mapping, Session and Workflow Creation
  • Session Properties
  • Link Condition Between Sessions
  • Multiple Target and Target Load Plan


  • Expression transformation
  • Filter transformation
  • Router transformation
  • Lookup transformation
  • Union transformation
  • Sorter transformation
  • Aggregator transformation
  • Rank transformation
  • Sequence generator transformation
  • Stored procedure transformation
  • & many more...
Advance topics -
  • Task, Session & Workflow properties
  • Reusability - Worklet & Maplet
  • Scheduling Workflow
  • Import - Export of Objects
  • Indirect File Load
  • Integrity Constraint Load Ordering
  • Session Parameters and Variables
  • Target Load Order Plan

Post Learning Guidance-

  • Important Interview Questions for Informatica ETL
  • Informatica Developer Resumes
Stop your search here and start learning now. Best for any user who is looking for -
  • Informatica tutorial
  • Informatica training
  • Informatica online training
  • Informatica power center ETL developer
  • Informatica power center for beginners
Who is the target audience?
  • Job seekers looking for exciting and well paid IT career
  • Professionals looking for salary raise by adding new skill in their profile
  • Fresher Graduates wanted to enter in IT market
  • Anyone wants to do career change and want to switch to IT industry market
Students Who Viewed This Course Also Viewed
Curriculum For This Course
184 Lectures
Introduction to Informatica
7 Lectures 27:46

Note on - Data Warehousing Concepts - Quick Overview

Roles and Responsibilities of Informatica Developer

Roles and Responsibilities of Informatica Administrator

What is Informatica PowerCenter (IPC)?
ETL and Various ETL Tools
2 Lectures 11:20
What is ETL?

Various ETL Tools in Market
Data Transformation
3 Lectures 12:12
What is Data Transformation

Types of Data Transformation

Example of Data Transformation
Informatica PowerCenter Components
6 Lectures 16:35
Informatica Power Center Components

PowerCenter Designer

Workflow Manager

Workflow Monitor

Repository Manager

Admin Console
Informatica PowerCenter Architecture
4 Lectures 15:30
Informatica Client-Server Architecture

Repository Services

Integration Service

What is domain
Installation and Configuration of Informatica PowerCenter
6 Lectures 14:46
Installation Steps Overview

Installation Options
3 pages

Prebuilt VM part 1 - How to

Prebuilt VM part 2 - How to

Prebuilt VM part 3 -How to

Pre Built VM Final
OPTION 2 - Real Installation on your PC
5 Lectures 30:40
Jan-7-2016-Updated-Installation path
2 pages

Oracle 11g Setup and Configuration

PowerCenter Server Setup and Configuration

PowerCenter Client Setup and Configuration

Steps of Installation
42 pages
Understanding Source and Target
4 Lectures 11:31
Types of Sources

Type of targets

Source Analyzer in Informatica

Target Designer in Informatica
Create Mappings, Session and Workflows
7 Lectures 01:12:14
Create a Mapping To load Source Table to Target Table

Create a Mapping to load Source Table to Flat file Target

Create a Mapping to load Flat File Source to Target Table

Creating a Session and Workflow

Note to students

Flat file with header record to Oracle Table

Summary Notes for Mapping, Session and Workflow Creation
24 pages
Session Properties
10 Lectures 47:44
Session properties Overview

Fail Parent if Task Fails

Write Backward Compatibility Session Log File

Bulk vs Normal Load

Save Session Log for These Runs

How to use Pre or Post SQL

How to Send Email

Stop on Error

Commit Interval

Summary Notes for Session Properties
9 pages
33 More Sections
About the Instructor
Kish Sat
3.8 Average rating
560 Reviews
4,874 Students
5 Courses
Senior Software Enginner/Data Architect/Project Manager

For the past 20 years, I have been working as Sr. Software Developer/Data Architect/Project Manager for various starting and large companies in several different domains.

I am a life-long learner. I love learning new topics and techniques.

I like research. I spend hours each week researching and keeping up on the latest trends in all of the fields that I operate in.

Vrunda Bakshi
3.8 Average rating
540 Reviews
4,502 Students
2 Courses
Sr. Architect

My  Job Duties:

  • Enhances information architecture team accomplishments and competence by planning delivery of solutions; answering technical and procedural questions for less experienced team members; teaching improved processes; mentoring team members.
  • Identifies user requirements by researching and analyzing user needs, preferences, objectives, and working methods; studying how users consume content, including data categorization and labeling; meeting with focus groups.
  • Plans information architecture by studying the site concept, strategy, and target audience; envisioning architectural scheme, information structure and features, functionality, and user-interface design; creating user scenarios; preparing data models; designing information structure, work-and dataflow, and navigation; evaluating information representation; conducting creative meetings.
  • Organizes information by translating user behavior into media structure and elements; crafting interactive experiences; producing workflow diagrams, user scenarios, flowcharts, and storyboards; preparing interaction specifications, navigation rules, organization of information, and site maps; coordinating with business, technology, visual, structural, editorial, cognitive, and brand strategists.
  • Implements information architecture by preparing paper and interactive prototypes and mockups including page layout and navigational elements; coordinating with Web Producer and Production Developer to integrate site concept, visual design, writing, interface, and navigational structure; documenting structure and processes.
  • Validates information delivery by developing and completing usability test plans; evaluating traffic patterns; studying user feedback; coordinating with Usability Specialists.
  • Updates job knowledge by tracking research regarding web design and usability; participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.
  • Enhances organization reputation by accepting ownership for accomplishing new and different requests; exploring opportunities to add value to job accomplishments.