Expert Online Informatica Training via High Quality Streaming Video

Informatica Powercenter Introduction & Basics Course

Video Run Time: 16 hrs

Number of Videos: 141

Classroom Equivalent: 4 days

Pre-Requisites: 6 to 8 months of IT systems experience

Audience: ETL Specialists, Data Integration Implementors, SQL Data Movement Experts

This comprehensive course covers the fundamentals including: What is Informatica? How does it work? How do I work with it? This course covers Informatica from top to bottom in the core architecture of the product. The instructor will take the student through the architectural components, the Designer, Workflow Manager, Workflow Monitor, Repository Manager, and server configurations and setup. It will cover basic concepts about mapping design, workflow design, and process monitoring.

During the class, the student will learn about each of the transformation objects, what they are for, and how they might be used to solve specific business problems. This course is equivalent (in agenda only) to Informatica PowerCenter Level 1 Developer. *** This course is CUSTOM BUILT by Dan Linstedt and takes you far beyond Informatica's standard training materials. It covers concepts not found in user manuals, blogs, or anywhere else!

Course Outline:

Introduction and Architecture

1.1 Architecture and Software Overview (7 min)
1.2 ETL and ELT Architecture Overview (8 min)
1.3 Partitioning and Parallelism Introduction (10 min)
1.4 PowerCenter Services RAM Utilization (13 min)
1.5 Differences Between 32 bit and 64 bit (10 min)

Client Software Overview

2.1 Introduction to Designer Interface (5 min)
2.2 Introduction to Workflow Manager Interface (5 min)
2.3 Introduction to Workflow Monitor (5 min)
2.4 Introduction to Repository Manager (5 min)
2.5 Nature of ODBC in the Designer (6 min)
2.6 Software Demonstration (5 min)

Source Object Definitions

3.1 Flat File Sources (20 min)
3.2 Relational Sources (6 min)
3.3 Data Previewer (5 min)
3.4 Metadata Extensions (4 min)
3.5 LAB: Import a Source (21 min)

Target Object Definitions

4.1 Target Definitions (4 min)
4.2 Target Properties (4 min)
4.3 Flat File Targets (2 min)
4.4 Relational Targets (4 min)
4.5 LAB: Import a Target (8 min)

Mappings

5.1 Defining a Data Flow Diagram (9 min)
5.2 Transformation Objects and Views (5 min)
5.3 Source Definition and Source Qualifier (3 min)
5.4 Pre-SQL and Post-SQL Rules (9 min)
5.5 Expression Transformation (10 min)
5.6 Informatica Functions (11 min)
5.7 Variable Ports (10 min)
5.8 Data Types (6 min)
5.9 Mapping Validation (4 min)
5.10 LAB: Create a Working Mapping (8 min)

Workflows

6.1 Workflow Tools (8 min)
6.2 Workflow Structure (2 min)
6.3 Workflow Connections (5 min)
6.4 Workflow Tasks (7 min)
6.5 Workflow Design Process (4 min)
6.6 Workflow Properties (10 min)
6.7 Workflow Links (4 min)
6.8 Session Tasks (17 min)
6.9 LAB: Configure a Workflow and Session (13 min)

Monitoring Workflows

7.1 Workflow Monitor Views (8 min)
7.2 Monitoring a Server (3 min)
7.3 Actions Initiated from the Workflow Monitor (9 min)
7.4 Filtering Views (2 min)
7.5 Truncating Monitor Logs (4 min)
7.6 Stop Versus Abort (6 min)
7.7 LAB: Run and Monitor the Workflow (9 min)
7.8 LAB: Demonstration of Designer Features (8 min)

Debugger

8.1 Debugger Features (5 min)
8.2 Debugger Windows and Indicators (13 min)
8.3 Debugger Best Practices (6 min)
8.4 LAB: Debug the Mapping (12 min)

Filter Transformation

9.1 Filter Functionality (2 min)
9.2 Filter Properties (7 min)
9.3 Filter Versus DB Where Clause (3 min)
9.4 LAB: Create a Filter Transformation, Run Workflow (9 min)

Sorter Transformation

10.1 Sorter Functionality (4 min)
10.2 Sorter Properties (5 min)
10.3 Sorter Versus Database Order by Clause (6 min)

Aggregator Transformation

11.1 Aggregator Transformation (5 min)
11.2 Aggregator Expressions and Functions (8 min)
11.3 Using Unsorted and Sorted Data (7 min)
11.4 Data Flow Rules (8 min)
11.5 Aggregator Versus Database Group By (5 min)

Joiner Transformation

12.1 Homogeneous and Heterogeneous Joins (6 min)
12.2 Joiner Conditions and Properties (14 min)
12.3 Joiner Usage (8 min)
12.4 Nested Joins (2 min)
12.5 Joiner Versus Database Join (4 min)
12.6 LAB: Add Sorter, Joiner, and Aggregator (26 min)

Lookup Transformation

13.1 Lookup Principles (9 min)
13.2 Lookup Properties (11 min)
13.3 Lookup Caching (8 min)
13.4 Lookup Versus Database Join (5 min)
13.5 LAB: Create a Basic Lookup (9 min)

Target Options

14.1 Target Properties (17 min)
14.2 WHERE Clause (4 min)
14.3 Constraint-Based Loading (6 min)
14.4 Target SQL Override Best Practices (2 min)

Update Strategy Transformation

15.1 Update Strategy Transformation (10 min)
15.2 Update Strategy Expressions (2 min)
15.3 Update Strategy Best Practices (2 min)
15.4 LAB: Create a Type 2 Dimension Update (29 min)

Router Transformation

16.1 Router Functionality (5 min)
16.2 Router Groups (9 min)
16.3 LAB: Use a Router to Delete Rows (12 min)
16.4 LAB: Data Driven Versus Session Switches (26 min)

Parameters and Variables

17.1 Parameter Scoping (12 min)
17.2 System Variables (3 min)
17.3 Mapping Parameters and Variables (3 min)
17.4 Variable Functions (5 min)

Unconnected Lookups

18.1 Usage and Techniques (5 min)
18.2 Advantages (3 min)
18.3 Functionality (1 min)
18.4 Conditional Lookups (3 min)
18.5 LAB: Create an Unconnected Lookup (11 min)

Heterogeneous Targets

19.1 Heterogeneous Target Types (3 min)
19.2 Target Type Limitations and Conversions (6 min)
19.3 LAB: Build Heterogeneous Targets (5 min)

Mapplets

20.1 Mapplet Designer (3 min)
20.2 Mapplet Advantages (7 min)
20.3 Mapplet Types and Rules (11 min)
20.4 Active and Passive Mapplets (4 min)
20.5 Mapplet Parameters and Variables (6 min)
20.6 Mapplet Designer Best Practices (4 min)
20.7 LAB: Build a Mapplet (5 min)

Reusable Transformations

21.1 Transformation Developer (10 min)
21.2 Rules (3 min)
21.3 Promoting and Copying Transformations (4 min)
21.4 Transformation Developer Best Practices (3 min)
21.5 LAB: Create and Use a Reusable Transformation (8 min)

Sequence Generator Transformation

22.1 Sequence Generator Functionality (6 min)
22.2 Sequence Generator Properties (7 min)
22.3 Sequence Generator Best Practices (14 min)
22.4 LAB: Create a Variable Based Sequence Generator (10 min)

Error Logging

23.1 Setting On and Off (9 min)
23.2 Data Rejects with Error Logging Off (5 min)
23.3 Error Logging to Database Table and Flat File (5 min)
23.4 Source Row Logging (2 min)
23.5 Error Logging Best Practice Architecture (8 min)

Workflow Configuration

24.1 Server Connections (16 min)
24.2 Reusable Workflow Schedules (8 min)
24.3 Reusable Session Configurations (13 min)
24.4 LAB: Create a Sequential Workflow (3 min)
24.5 LAB: Create a Concurrent Workflow (4 min)

Reusable Tasks

25.1 The Command Task (10 min)
25.2 The Email Task (12 min)
25.3 Reusable Task Best Practices (3 min)

Non-Reusable Tasks

26.1 The Decision Task (4 min)
26.2 The Assignment Task (6 min)
26.3 The Timer Task (4 min)
26.4 The Control Task (2 min)
26.5 The Event Wait Task (5 min)
26.6 The Event Raise Task (5 min)
26.7 Non-Reusable Tasks Best Practices (4 min)
26.8 LAB: Create Event Wait/Event Raise and Timer (4 min)
26.9 LAB: Create a Control and Assignment Task (7 min)
26.10 LAB: Create a Command Line Task (3 min)

Worklets

27.1 Reusable Worklet (3 min)
27.2 Non-Reusable Worklet (4 min)
27.3 Worklet Best Practices (4 min)