Section 1 : Introduction to Informatica

lecture 1 Introduction to Course. 2:44
lecture 2 Where Informatica PowerCenter (IPC) is used
lecture 3 Note on - Data Warehousing Concepts - Quick Overvi Text
lecture 4 Data Warehouse projects and Why use Informatica 6:40
lecture 5 Roles and Responsibilities of Informatica Develope 4:18
lecture 6 Roles and Responsibilities of Informatica Administ 3:14
lecture 7 What is Informatica PowerCenter (IPC) 5:22

Section 2 : ETL and Various ETL Tools

lecture 8 What is ETL
lecture 9 Various ETL Tools in Market 2:11

Section 3 : Data Transformation

lecture 10 What is Data Transformation 3:41
lecture 11 Types of Data Transformation 5:30
lecture 12 Example of Data Transformation 5:30

Section 4 : Informatica PowerCenter Components

lecture 13 Informatica Power Center Components 1:28
lecture 14 PowerCenter Designer 3:9
lecture 15 Workflow Manager
lecture 16 Workflow Monitor 3:12
lecture 17 Repository Manager 3:1
lecture 18 Admin Console 3:11

Section 5 : Informatica PowerCenter Architecture

lecture 19 Informatica Client-Server Architecture 6:54
lecture 20 Repository Services 3:4
lecture 21 Integration Service 2:42
lecture 22 What is domain 2:51

Section 6 : Installation and Configuration of Informatica PowerCenter

lecture 23 Installation Steps Overview 3:37
lecture 24 Installation Options Pdf
lecture 25 Prebuilt VM part 1 - How to
lecture 26 Prebuilt VM part 2 - How to 4:34
lecture 27 Prebuilt VM part 3 -How to 3:57
lecture 28 INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM Pdf

Section 7 : OPTION 2 - Real Installation on your PC

lecture 29 Jan-7-2016-Updated-Installation path Pdf
lecture 30 Oracle 11g Setup and Configuration 8:21
lecture 31 PowerCenter Server Setup and Configuration 14:52
lecture 32 PowerCenter Client Setup and Configuration 7:29
lecture 33 Steps of Installation Pdf

Section 8 : Understanding Source and Target

lecture 34 Types of Sources 3:6
lecture 35 Type of targets 2:23
lecture 36 Source Analyzer in Informatica 4:4
lecture 37 Target Designer in Informatica 2:1

Section 9 : Create Mappings, Session and Workflows

lecture 38 Create a Mapping To load Source Table to Target Ta 10:5
lecture 39 Create a Mapping to load Source Table to Flat file 8:17
lecture 40 Create a Mapping to load Flat File Source to Targe 8:26
lecture 41 Creating a Session and Workflow 13:50
lecture 42 Note to students Text
lecture 43 Flat file with header record to Oracle Table 31:17
lecture 44 Summary Notes for Mapping, Session and Workflow Cr Pdf

Section 10 : Session Properties

lecture 45 Session properties Overview 2:27
lecture 46 Fail Parent if Task Fails 7:50
lecture 47 Write Backward Compatibility Session Log File 5:7
lecture 48 Bulk vs Normal Load 5:55
lecture 49 Save Session Log for These Runs 5:2
lecture 50 How to use Pre or Post SQL 6:14
lecture 51 How to Send Email 4:11
lecture 52 Stop on Error 8:46
lecture 53 Commit Interval 2:16
lecture 54 Summary Notes for Session Properties Pdf

Section 11 : Link Conditions

lecture 55 Link Conditions Concept 1:20
lecture 56 Link Condition Example 15:20

Section 12 : Multiple Target and Target Load Plan

lecture 57 Loading Source data to multiple target - File and 12:16
lecture 58 Target Load Plan Concept 4:0
lecture 59 Target Load Plan Example 13:30
lecture 60 issues with having 2 pipeline loads in 1 mapping 1:52
lecture 61 Summary Multiple Target and Target Load Plan Pdf

Section 13 : Transformations

lecture 62 Active and Passive Transformations 8:38

Section 14 : Expression Transformation

lecture 63 Expression Transformation Concepts 5:38
lecture 64 Expression Transformation Example 16:1
lecture 65 IIF Expression Example 14:4
lecture 66 ERROR Function in Expression 14:50
lecture 67 ABORT Function in Expression 9:49
lecture 68 Difference between ERROR and ABORT 3:16
lecture 69 Expression Transformation Strategies Pdf

Section 15 : Filter Transformation

lecture 70 Filter Transformation Concept 4:24
lecture 71 Filter Transformation Example 9:8
lecture 72 Filter Transformation to Monitor Performance Conce 1:38
lecture 73 Filter Transformation to Monitor Performance Examp 7:43
lecture 74 Filter Transformation Strategies Pdf

Section 16 : Router Transformation

lecture 75 Router Transformation Concept 5:42
lecture 76 Router Transformation Example 14:45
lecture 77 Router Transformation Strategies Pdf

Section 17 : Joiner Transformation

lecture 78 Join Concept 15:51
lecture 79 Joiner Transformation (Inner or Equi Join) Example 13:17
lecture 80 Joiner Transformation (Right Outer Join) Example 13:8
lecture 81 Joiner Transformation (Left Outer Join) Example 13:22
lecture 82 Joiner Transformation (Full Outer Join) Example 13:30
lecture 83 Joiner Transformation Strategies Pdf

Section 18 : Lookup Transformation

lecture 48 Lookup Transformation Concept 7:35
lecture 85 Simple Lookup Table example 9:14
lecture 86 Lookup Transformation Multiple Match Values Concep 6:50
lecture 87 Lookup Transformation First Value Example 12:58
lecture 88 Lookup Transformation Last Value Example 4:22
lecture 89 Lookup Transformation Any Value Example 5:5
lecture 90 Lookup Transformation Report Error Example 4:20
lecture 91 Lookup Transformation UseAll Values Example 6:32
lecture 92 Unconnected and Connected Lookup Concept 4:54
lecture 93 Unonnected Lookup Example 6:51
lecture 94 Static Cache Lookup 20:14
lecture 95 Lookup Transformation Strategies Pdf

Section 19 : How to use Informatica Help

lecture 96 How to use Informatica Help for more functions 5:0

Section 20 : Union Transformation

lecture 97 Union Transformation Concept 7:42
lecture 98 Union Transformation Example 9:21
lecture 99 Union Transformation Strategies Zip

Section 21 : Sorter Transformation

lecture 100 Sorter Transformation Concept 3:58
lecture 101 Sorter Transformation Example with 1 key 6:36
lecture 102 Sorter Transformation Example with more than 1 key 3:30
lecture 103 Sorter Transformation to get unique records after 4:51
lecture 104 Sorter Transformation Strategies Pdf

Section 22 : Aggregator Transformation

lecture 105 Aggregator Transformation concepts 6:12
lecture 106 Aggregator Transformation Example 9:46
lecture 107 Use of Aggregator to remove duplicates Concept 3:53
lecture 108 Use of Aggregator to remove duplicates Example 3:54
lecture 109 Aggregator Transformation Strategies Pdf

Section 23 : Rank Transformation

lecture 110 Rank Transformation Concept 5:55
lecture 111 Rank Transformation Example - Using TopBottom Rank 9:4
lecture 112 Rank Transformation Strategies Pdf

Section 24 : Rank Transformation Strategies

lecture 113 Sequence Generator Transformation Concept 6:15
lecture 114 Sequence Generator Transformation Example 4:14
lecture 115 Sequence Generator Transformation Strategies Pdf

Section 25 : Stored Procedure Transformation

lecture 116 Stored Procedure Transformation Concept 4:20
lecture 117 Stored Procedure Transformation Example 5:53
lecture 118 Stored Procedure Transformation Strategies Pdf

Section 26 : Source Qualifier Transformation

lecture 119 Relational Table - Source Qualifier Transformation 18:33
lecture 120 Flat File - Source Qualifier Transformation 11:58

Section 27 : Update Strategy Transformation

lecture 121 Update Strategy Transformation Part 1 15:0
lecture 122 Update Strategy Transformation Part 2 10:43

Section 28 : Example of Mapping containing Multiple Transformations

lecture 123 Example of Mapping containing Multiple Transformat 23:8

Section 29 : Slowly Changing Dimension

lecture 124 Slowly Changing Dimension Concept 13:3
lecture 125 SCD Type1 Concept 3:0
lecture 126 SCD Type1 Example 13:13
lecture 127 SCD Type2 Concep 3:58
lecture 128 SCD Type2 Example 15:18
lecture 129 SCD Type3 Concept 1:45
lecture 130 SCD Type3 Example 9:48
lecture 131 Slowly Changing Dimension Strategies Pdf

Section 30 : Workflow

lecture 132 What is Workflow 4:12
lecture 133 Creating Workflow 3:17
lecture 134 Monitoring workflows and debugging errors 5:27

Section 31 : Tasks

lecture 135 What is Task 2:55
lecture 136 reating Decision task 4:28
lecture 137 Creating Control Task 4:17
lecture 138 Creating Event wait task 4:47
lecture 139 Creating Timer task 2:30
lecture 140 What is Reusable tasks - session, email and comman 2:17
lecture 141 Creating Reusable tasks 3:1

Section 32 : Reusability - Worklet & Maplet

lecture 142 What is Worklet 1:45
lecture 143 Creating Worklet 2:35
lecture 144 What is Maplet 6:32
lecture 145 Creating Maplet 4:35
lecture 146 Reusable Transformations Concept 1:13
lecture 147 Reusable Transformations Example 3:18
lecture 148 Reusability - Worklet & Maplet Startegies Summary Pdf

Section 33 : Sessions

lecture 149 What is Session 9:12
lecture 150 Creating Session 3:30

Section 34 : Scheduling Workflow

lecture 151 What is Scheduler 5:36
lecture 152 Using Scheduler to run example 2:10

Section 35 : Import - Export of Objects

lecture 153 Export Example 6:38
lecture 154 Import Example 2:11
lecture 155 Folder Copy 2:41

Section 36 : Indirect File Load

lecture 156 Indirect File Load Concept & Examples 5:19

Section 37 : Integrity Constraint Load Ordering

lecture 157 Integrity Constraint concept 3:58
lecture 158 primary key and foreign key example 1:45
lecture 159 Constraint based loading example 9:7
lecture 160 Integrity Constraint Load Ordering Strategies Pdf

Section 38 : Session Parameters and Variables

lecture 161 Session Parameters Concept 3:15
lecture 162 Session Parameters Example 5:29
lecture 163 Parameter Files Text
lecture 164 Session Parameters and Variables Strategies Pdf

Section 39 : Target Load Order Plan

lecture 165 Traget Load plan Concept 4:0
lecture 166 Where or When we need Target Load Plan 1:24
lecture 167 Traget Load plan Example 13:30
lecture 168 Target Load Order Plan Startegies Pdf

Section 40 : XML File Load to Oracle Table

lecture 169 XML File to Oracle Table 23:1

Section 41 : Data Warehousing Concepts - Quick Overview

lecture 170 Data Warehouse 1:38
lecture 171 Data Mart 2:30
lecture 172 Data Mart Example 1:50
lecture 173 OLAP VS OLTP 2:51
lecture 174 Data Warehouse Architecture (Basic) 2:24
lecture 175 Data Warehouse Architecture (with a Staging Area) 1:54
lecture 176 Dimensional Modeling 2:57
lecture 177 Star Schema 2:49
lecture 178 Snowflake Schema 2:9
lecture 179 Dimension 2:35
lecture 180 Fact 2:18
lecture 181 Slowly Changing Dimension 2:39
lecture 182 Hierarchy 1:55

Section 42 : Informatica Interview Questions

lecture 183 Informatica Interview Questions Pdf

Section 43 : Router and Joiner Summary

lecture 184 Router and Joiner Summary Part 1 1:25:27