Introduction to Informatica
  • Introduction to Course
  • Where Informatica PowerCenter (IPC) is used?
  • Note on - Data Warehousing Concepts - Quick Overview
  • Data Warehouse projects and Why use Informatica
  • Roles and Responsibilities of Informatica Developer
  • Roles and Responsibilities of Informatica Administrator
  • What is Informatica PowerCenter (IPC)?
ETL and Various ETL Tools
  • What is ETL?
  • Various ETL Tools in Market
Data Transformation
  • What is Data Transformation
  • Types of Data Transformation
  • Example of Data Transformation
Informatica PowerCenter Components
  • Informatica Power Center Components
  • PowerCenter Designer
  • Workflow Manager
  • Workflow Monitor
  • Repository Manager
  • Admin Console
Informatica PowerCenter Architecture
  • Informatica Client-Server Architecture
  • Repository Services
  • Integration Service
  • What is domain
Installation and Configuration of Informatica PowerCenter
  • Installation Steps Overview
  • Installation Options
  • 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
  • Jan-7-2016-Updated-Installation path
  • Oracle 11g Setup and Configuration
  • PowerCenter Server Setup and Configuration
  • PowerCenter Client Setup and Configuration
  • Steps of Installation
Understanding Source and Target
  • Types of Sources
  • Type of targets
  • Source Analyzer in Informatica
  • Target Designer in Informatica
Create Mappings, Session and Workflows
  • 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
Session Properties
  • 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
Link Conditions
  • Link Conditions Concept
  • Link Condition Example
Multiple Target and Target Load Plan
  • Loading Source data to multiple target - File and Relational
  • Target Load Plan Concept
  • Target Load Plan Example
  • Issues with having 2 pipeline loads in 1 mapping
  • Summary Multiple Target and Target Load Plan
Transformations
  • Active and Passive Transformations
Expression Transformation
  • Expression Transformation Concepts
  • Expression Transformation Example
  • IIF Expression Example
  • ERROR Function in Expression
  • ABORT Function in Expression
  • Difference between ERROR and ABORT
  • Expression Transformation Strategies
Filter Transformation
  • Filter Transformation Concept
  • Filter Transformation Example
  • Filter Transformation to Monitor Performance Concept
  • Filter Transformation to Monitor Performance Example
  • Filter Transformation Strategies
Router Transformation
  • Router Transformation Concept
  • Router Transformation Example
  • Router Transformation Strategies
Joiner Transformation
  • Join Concept
  • Joiner Transformation (Inner or Equi Join) Example
  • Joiner Transformation (Right Outer Join) Example
  • Joiner Transformation (Left Outer Join) Example
  • Joiner Transformation (Full Outer Join) Example
  • Joiner Transformation Strategies