Section 1 : Introduction to Informatica
|
|
Lecture 1 | Introduction to Course. | 00:02:44 Duration |
|
|
Lecture 2 | Where Informatica PowerCenter (IPC) is used | |
|
|
Lecture 3 | Note on - Data Warehousing Concepts - Quick Overvi | |
|
|
Lecture 4 | Data Warehouse projects and Why use Informatica | 00:06:40 Duration |
|
|
Lecture 5 | Roles and Responsibilities of Informatica Develope | 00:04:18 Duration |
|
|
Lecture 6 | Roles and Responsibilities of Informatica Administ | 00:03:14 Duration |
|
|
Lecture 7 | What is Informatica PowerCenter (IPC) | 00:05:22 Duration |
Section 2 : ETL and Various ETL Tools
|
|
Lecture 1 | What is ETL | |
|
|
Lecture 2 | Various ETL Tools in Market | 00:02:11 Duration |
Section 3 : Data Transformation
|
|
Lecture 1 | What is Data Transformation | 00:03:41 Duration |
|
|
Lecture 2 | Types of Data Transformation | 00:05:30 Duration |
|
|
Lecture 3 | Example of Data Transformation | 00:05:30 Duration |
Section 4 : Informatica PowerCenter Components
|
|
Lecture 1 | Informatica Power Center Components | 00:01:28 Duration |
|
|
Lecture 2 | PowerCenter Designer | 00:03:09 Duration |
|
|
Lecture 3 | Workflow Manager | |
|
|
Lecture 4 | Workflow Monitor | 00:03:12 Duration |
|
|
Lecture 5 | Repository Manager | 00:03:01 Duration |
|
|
Lecture 6 | Admin Console | 00:03:11 Duration |
Section 5 : Informatica PowerCenter Architecture
|
|
Lecture 1 | Informatica Client-Server Architecture | 00:06:54 Duration |
|
|
Lecture 2 | Repository Services | 00:03:04 Duration |
|
|
Lecture 3 | Integration Service | 00:02:42 Duration |
|
|
Lecture 4 | What is domain | 00:02:51 Duration |
Section 6 : Installation and Configuration of Informatica PowerCenter
|
|
Lecture 1 | Installation Steps Overview | 00:03:37 Duration |
|
|
Lecture 2 | Installation Options | |
|
|
Lecture 3 | Prebuilt VM part 1 - How to | |
|
|
Lecture 4 | Prebuilt VM part 2 - How to | 00:04:34 Duration |
|
|
Lecture 5 | Prebuilt VM part 3 -How to | 00:03:57 Duration |
|
|
Lecture 6 | INTRODUCTION TO BRAINMEASURES PROCTOR SYSTEM |
Section 7 : OPTION 2 - Real Installation on your PC
|
|
Lecture 1 | Jan-7-2016-Updated-Installation path | |
|
|
Lecture 2 | Oracle 11g Setup and Configuration | 00:08:21 Duration |
|
|
Lecture 3 | PowerCenter Server Setup and Configuration | 00:14:52 Duration |
|
|
Lecture 4 | PowerCenter Client Setup and Configuration | 00:07:29 Duration |
|
|
Lecture 5 | Steps of Installation |
Section 8 : Understanding Source and Target
|
|
Lecture 1 | Types of Sources | 00:03:06 Duration |
|
|
Lecture 2 | Type of targets | 00:02:23 Duration |
|
|
Lecture 3 | Source Analyzer in Informatica | 00:04:04 Duration |
|
|
Lecture 4 | Target Designer in Informatica | 00:02:01 Duration |
Section 9 : Create Mappings, Session and Workflows
|
|
Lecture 1 | Create a Mapping To load Source Table to Target Ta | 00:10:05 Duration |
|
|
Lecture 2 | Create a Mapping to load Source Table to Flat file | 00:08:17 Duration |
|
|
Lecture 3 | Create a Mapping to load Flat File Source to Targe | 00:08:26 Duration |
|
|
Lecture 4 | Creating a Session and Workflow | 00:13:50 Duration |
|
|
Lecture 5 | Note to students | |
|
|
Lecture 6 | Flat file with header record to Oracle Table | 00:31:17 Duration |
|
|
Lecture 7 | Summary Notes for Mapping, Session and Workflow Cr |
Section 10 : Session Properties
|
|
Lecture 1 | Session properties Overview | 00:02:27 Duration |
|
|
Lecture 2 | Fail Parent if Task Fails | 00:07:50 Duration |
|
|
Lecture 3 | Write Backward Compatibility Session Log File | 00:05:07 Duration |
|
|
Lecture 4 | Bulk vs Normal Load | 00:05:55 Duration |
|
|
Lecture 5 | Save Session Log for These Runs | 00:05:02 Duration |
|
|
Lecture 6 | How to use Pre or Post SQL | 00:06:14 Duration |
|
|
Lecture 7 | How to Send Email | 00:04:11 Duration |
|
|
Lecture 8 | Stop on Error | 00:08:46 Duration |
|
|
Lecture 9 | Commit Interval | 00:02:16 Duration |
|
|
Lecture 10 | Summary Notes for Session Properties |
Section 11 : Link Conditions
|
|
Lecture 1 | Link Conditions Concept | 00:01:20 Duration |
|
|
Lecture 2 | Link Condition Example | 00:15:20 Duration |
Section 12 : Multiple Target and Target Load Plan
|
|
Lecture 1 | Loading Source data to multiple target - File and | 00:12:16 Duration |
|
|
Lecture 2 | Target Load Plan Concept | 00:04:00 Duration |
|
|
Lecture 3 | Target Load Plan Example | 00:13:30 Duration |
|
|
Lecture 4 | issues with having 2 pipeline loads in 1 mapping | 00:01:52 Duration |
|
|
Lecture 5 | Summary Multiple Target and Target Load Plan |
Section 13 : Transformations
|
|
Lecture 1 | Active and Passive Transformations | 00:08:38 Duration |
Section 14 : Expression Transformation
|
|
Lecture 1 | Expression Transformation Concepts | 00:05:38 Duration |
|
|
Lecture 2 | Expression Transformation Example | 00:16:01 Duration |
|
|
Lecture 3 | IIF Expression Example | 00:14:04 Duration |
|
|
Lecture 4 | ERROR Function in Expression | 00:14:50 Duration |
|
|
Lecture 5 | ABORT Function in Expression | 00:09:49 Duration |
|
|
Lecture 6 | Difference between ERROR and ABORT | 00:03:16 Duration |
|
|
Lecture 7 | Expression Transformation Strategies |
Section 15 : Filter Transformation
|
|
Lecture 1 | Filter Transformation Concept | 00:04:24 Duration |
|
|
Lecture 2 | Filter Transformation Example | 00:09:08 Duration |
|
|
Lecture 3 | Filter Transformation to Monitor Performance Conce | 00:01:38 Duration |
|
|
Lecture 4 | Filter Transformation to Monitor Performance Examp | 00:07:43 Duration |
|
|
Lecture 5 | Filter Transformation Strategies |
Section 16 : Router Transformation
|
|
Lecture 1 | Router Transformation Concept | 00:05:42 Duration |
|
|
Lecture 2 | Router Transformation Example | 00:14:45 Duration |
|
|
Lecture 3 | Router Transformation Strategies |
Section 17 : Joiner Transformation
|
|
Lecture 1 | Join Concept | 00:15:51 Duration |
|
|
Lecture 2 | Joiner Transformation (Inner or Equi Join) Example | 00:13:17 Duration |
|
|
Lecture 3 | Joiner Transformation (Right Outer Join) Example | 00:13:08 Duration |
|
|
Lecture 4 | Joiner Transformation (Left Outer Join) Example | 00:13:22 Duration |
|
|
Lecture 5 | Joiner Transformation (Full Outer Join) Example | 00:13:30 Duration |
|
|
Lecture 6 | Joiner Transformation Strategies |
Section 18 : Lookup Transformation
|
|
Lecture 1 | Lookup Transformation Concept | 00:07:35 Duration |
|
|
Lecture 2 | Simple Lookup Table example | 00:09:14 Duration |
|
|
Lecture 3 | Lookup Transformation Multiple Match Values Concep | 00:06:50 Duration |
|
|
Lecture 4 | Lookup Transformation First Value Example | 00:12:58 Duration |
|
|
Lecture 5 | Lookup Transformation Last Value Example | 00:04:22 Duration |
|
|
Lecture 6 | Lookup Transformation Any Value Example | 00:05:05 Duration |
|
|
Lecture 7 | Lookup Transformation Report Error Example | 00:04:20 Duration |
|
|
Lecture 8 | Lookup Transformation UseAll Values Example | 00:06:32 Duration |
|
|
Lecture 9 | Unconnected and Connected Lookup Concept | 00:04:54 Duration |
|
|
Lecture 10 | Unonnected Lookup Example | 00:06:51 Duration |
|
|
Lecture 11 | Static Cache Lookup | 00:20:14 Duration |
|
|
Lecture 12 | Lookup Transformation Strategies |
Section 19 : How to use Informatica Help
|
|
Lecture 1 | How to use Informatica Help for more functions | 00:05:00 Duration |
Section 20 : Union Transformation
|
|
Lecture 1 | Union Transformation Concept | 00:07:42 Duration |
|
|
Lecture 2 | Union Transformation Example | 00:09:21 Duration |
|
|
Lecture 3 | Union Transformation Strategies |
Section 21 : Sorter Transformation
|
|
Lecture 1 | Sorter Transformation Concept | 00:03:58 Duration |
|
|
Lecture 2 | Sorter Transformation Example with 1 key | 00:06:36 Duration |
|
|
Lecture 3 | Sorter Transformation Example with more than 1 key | 00:03:30 Duration |
|
|
Lecture 4 | Sorter Transformation to get unique records after | 00:04:51 Duration |
|
|
Lecture 5 | Sorter Transformation Strategies |
Section 22 : Aggregator Transformation
|
|
Lecture 1 | Aggregator Transformation concepts | 00:06:12 Duration |
|
|
Lecture 2 | Aggregator Transformation Example | 00:09:46 Duration |
|
|
Lecture 3 | Use of Aggregator to remove duplicates Concept | 00:03:53 Duration |
|
|
Lecture 4 | Use of Aggregator to remove duplicates Example | 00:03:54 Duration |
|
|
Lecture 5 | Aggregator Transformation Strategies |
Section 23 : Rank Transformation
|
|
Lecture 1 | Rank Transformation Concept | 00:05:55 Duration |
|
|
Lecture 2 | Rank Transformation Example - Using TopBottom Rank | 00:09:04 Duration |
|
|
Lecture 3 | Rank Transformation Strategies |
Section 24 : Rank Transformation Strategies
|
|
Lecture 1 | Sequence Generator Transformation Concept | 00:06:15 Duration |
|
|
Lecture 2 | Sequence Generator Transformation Example | 00:04:14 Duration |
|
|
Lecture 3 | Sequence Generator Transformation Strategies |
Section 25 : Stored Procedure Transformation
|
|
Lecture 1 | Stored Procedure Transformation Concept | 00:04:20 Duration |
|
|
Lecture 2 | Stored Procedure Transformation Example | 00:05:53 Duration |
|
|
Lecture 3 | Stored Procedure Transformation Strategies |
Section 26 : Source Qualifier Transformation
|
|
Lecture 1 | Relational Table - Source Qualifier Transformation | 00:18:33 Duration |
|
|
Lecture 2 | Flat File - Source Qualifier Transformation | 00:11:58 Duration |
Section 27 : Update Strategy Transformation
|
|
Lecture 1 | Update Strategy Transformation Part 1 | 00:15:00 Duration |
|
|
Lecture 2 | Update Strategy Transformation Part 2 | 00:10:43 Duration |
Section 28 : Example of Mapping containing Multiple Transformations
|
|
Lecture 1 | Example of Mapping containing Multiple Transformat | 00:23:08 Duration |
Section 29 : Slowly Changing Dimension
|
|
Lecture 1 | Slowly Changing Dimension Concept | 00:13:03 Duration |
|
|
Lecture 2 | SCD Type1 Concept | 00:03:00 Duration |
|
|
Lecture 3 | SCD Type1 Example | 00:13:13 Duration |
|
|
Lecture 4 | SCD Type2 Concep | 00:03:58 Duration |
|
|
Lecture 5 | SCD Type2 Example | 00:15:18 Duration |
|
|
Lecture 6 | SCD Type3 Concept | 00:01:45 Duration |
|
|
Lecture 7 | SCD Type3 Example | 00:09:48 Duration |
|
|
Lecture 8 | Slowly Changing Dimension Strategies |
Section 30 : Workflow
|
|
Lecture 1 | What is Workflow | 00:04:12 Duration |
|
|
Lecture 2 | Creating Workflow | 00:03:17 Duration |
|
|
Lecture 3 | Monitoring workflows and debugging errors | 00:05:27 Duration |
Section 31 : Tasks
|
|
Lecture 1 | What is Task | 00:02:55 Duration |
|
|
Lecture 2 | reating Decision task | 00:04:28 Duration |
|
|
Lecture 3 | Creating Control Task | 00:04:17 Duration |
|
|
Lecture 4 | Creating Event wait task | 00:04:47 Duration |
|
|
Lecture 5 | Creating Timer task | 00:02:30 Duration |
|
|
Lecture 6 | What is Reusable tasks - session, email and comman | 00:02:17 Duration |
|
|
Lecture 7 | Creating Reusable tasks | 00:03:01 Duration |
Section 32 : Reusability - Worklet & Maplet
|
|
Lecture 1 | What is Worklet | 00:01:45 Duration |
|
|
Lecture 2 | Creating Worklet | 00:02:35 Duration |
|
|
Lecture 3 | What is Maplet | 00:06:32 Duration |
|
|
Lecture 4 | Creating Maplet | 00:04:35 Duration |
|
|
Lecture 5 | Reusable Transformations Concept | 00:01:13 Duration |
|
|
Lecture 6 | Reusable Transformations Example | 00:03:18 Duration |
|
|
Lecture 7 | Reusability - Worklet & Maplet Startegies Summary |
Section 33 : Sessions
|
|
Lecture 1 | What is Session | 00:09:12 Duration |
|
|
Lecture 2 | Creating Session | 00:03:30 Duration |
Section 34 : Scheduling Workflow
|
|
Lecture 1 | What is Scheduler | 00:05:36 Duration |
|
|
Lecture 2 | Using Scheduler to run example | 00:02:10 Duration |
Section 35 : Import - Export of Objects
|
|
Lecture 1 | Export Example | 00:06:38 Duration |
|
|
Lecture 2 | Import Example | 00:02:11 Duration |
|
|
Lecture 3 | Folder Copy | 00:02:41 Duration |
Section 36 : Indirect File Load
|
|
Lecture 1 | Indirect File Load Concept & Examples | 00:05:19 Duration |
Section 37 : Integrity Constraint Load Ordering
|
|
Lecture 1 | Integrity Constraint concept | 00:03:58 Duration |
|
|
Lecture 2 | primary key and foreign key example | 00:01:45 Duration |
|
|
Lecture 3 | Constraint based loading example | 00:09:07 Duration |
|
|
Lecture 4 | Integrity Constraint Load Ordering Strategies |
Section 38 : Session Parameters and Variables
|
|
Lecture 1 | Session Parameters Concept | 00:03:15 Duration |
|
|
Lecture 2 | Session Parameters Example | 00:05:29 Duration |
|
|
Lecture 3 | Parameter Files | |
|
|
Lecture 4 | Session Parameters and Variables Strategies |
Section 39 : Target Load Order Plan
|
|
Lecture 1 | Traget Load plan Concept | 00:04:00 Duration |
|
|
Lecture 2 | Where or When we need Target Load Plan | 00:01:24 Duration |
|
|
Lecture 3 | Traget Load plan Example | 00:13:30 Duration |
|
|
Lecture 4 | Target Load Order Plan Startegies |
Section 40 : XML File Load to Oracle Table
|
|
Lecture 1 | XML File to Oracle Table | 00:23:01 Duration |
Section 41 : Data Warehousing Concepts - Quick Overview
|
|
Lecture 1 | Data Warehouse | 00:01:38 Duration |
|
|
Lecture 2 | Data Mart | 00:02:30 Duration |
|
|
Lecture 3 | Data Mart Example | 00:01:50 Duration |
|
|
Lecture 4 | OLAP VS OLTP | 00:02:51 Duration |
|
|
Lecture 5 | Data Warehouse Architecture (Basic) | 00:02:24 Duration |
|
|
Lecture 6 | Data Warehouse Architecture (with a Staging Area) | 00:01:54 Duration |
|
|
Lecture 7 | Dimensional Modeling | 00:02:57 Duration |
|
|
Lecture 8 | Star Schema | 00:02:49 Duration |
|
|
Lecture 9 | Snowflake Schema | 00:02:09 Duration |
|
|
Lecture 10 | Dimension | 00:02:35 Duration |
|
|
Lecture 11 | Fact | 00:02:18 Duration |
|
|
Lecture 12 | Slowly Changing Dimension | 00:02:39 Duration |
|
|
Lecture 13 | Hierarchy | 00:01:55 Duration |
Section 42 : Informatica Interview Questions
|
|
Lecture 1 | Informatica Interview Questions |
Section 43 : Router and Joiner Summary
|
|
Lecture 1 | Router and Joiner Summary Part 1 | 01:25:27 Duration |
