Informatica Power Center Training - 50 Hours - $500 Per Student

[D2trainings]

Informatica Power Center Training - 50 Hours - $500 per student

Empire Data Systems - #1 Database Training hose in USA!!!

 

Call me now @267 718 1533  for a career discussion 

 

General information about the course

§  Most comprehensive Informatica Power Center course with Hands-On lab exercise in USA.

§  Trained by MASTER Informatica Developer and Admin with 5+ year’s industry experience. 

§  Total duration of the course is 50 hours.

§  Course fee is $500 per student.

§  Course schedule is Monday to Friday 8:00PM to 10:30 PM Eastern Time.

§  After each class, you will get

ü  Excellent course material.

ü  Hands-On LAB exercises which you need to finish before next class.

ü  Recorded video of the live class which you can keep it forever and review it later.

 

See our comprehensive course content below…  Believe me, you will not be disappointed!!!

 

 

About the trainer

Mr. Sandeep has over 5+ years of Strong Data Warehouse & ETL Data Integration & Migration experience in Financial/Banking Domain using Informatica PowerCenter 8x & 9x (Informatica Admin Console, Repository Manager, Mapping Designer, Mapplet Designer, Transformation Designer, Debugger, Workflow Manager, Task Developer, Worklet Designer, Workflow Monitor, Scheduling, Performance Tuning, hands-on in Installation, Configuration, and Administration of Informatica Power Center Client and Server), alongside, have an extensive knowledge in working with relational DBs using Oracle 10/11g (PL/SQL , Procedures/Functions & Triggers), PostgreSql, & other systems like CSV/Flatfiles, applications such as SalesForce.com etc. He is an expert in Informatica Cloud to Design Data Conversions and Loads & Scheduling using Autosys and Informatica In-built Scheduler tools.

 

 

Informatica Course Content

Data Warehouse Concepts

1.1 Introduction to Data warehouse

1.2 What is Data warehouse and why we need Data warehouse

1.3 OLTP vs OLAP vs Data warehouse

1.4 Star schema/Snowflake schema/Galaxy schema

1.5 Dimensions / Facts tables.

1.6 Slowly Changing Dimensions and its types.

1.7 Data Mart vs Data warehouse

 

Introduction and Architecture

1.1 ETL (Extract-transform-load) Overview

1.2 Informatica PowerCenter as an ETL tool.

1.3 Architecture and Software Overview

1.4 Definition of Domain, Repositories, Integration Services.

1.5 Metadata Introduction

1.6 Overview of Informatica PowerCenter Administration Console.

 

Installation

2.1 Download Informatica PowerCenter and Oracle database.

2.2 Install PowerCenter Server and Client.

2.3 Informatica Power Center Installation directories.

 

Client Software Overview

3.1 Introduction to Designer Interface

3.2 Introduction to Workflow Manager Interface

3.3 Introduction to Workflow Monitor

3.4 Introduction to Repository Manager

3.5 Nature of ODBC in the Designer

3.6 Software Demonstration

 

Source Object Definitions

4.1 Flat File Sources

4.2 Relational Sources

4.3 Data Previewer

4.4 LAB: Import a Source

4.5 LAB: Create a Source manually.

 

Target Object Definitions

5.1 Target Definitions

5.2 Target Properties

5.3 Flat File Targets

5.4 Relational Targets

5.5 LAB: Import a Target

5.6 LAB: Create a Target, manually.

 

Mappings

6.1 Defining a Data Flow Diagram

6.2 Transformation Objects and Views

6.3 Source Definition and Source Qualifier

6.4 Pre-SQL and Post-SQL Rules

6.5 Expression Transformation

6.6 Informatica Functions

6.7 Variable Ports

6.8 Data Types

6.9 Mapping Validation

6.10 LAB: Create a Working Mapping

 

Workflows

7.1 Workflow Tools

7.2 Workflow Structure

7.3 Workflow Connections

7.4 Workflow Tasks

7.5 Workflow Design Process

7.6 Workflow Properties

7.7 Workflow Links

7.8 Session Tasks

7.9 LAB: Configure a Workflow and Session. And call previously created mapping.

7.10 LAB: Command line execution of a workflow.

 

Monitoring Workflows

8.1 Workflow Monitor Views

8.2 Monitoring a Server

8.3 Actions Initiated from the Workflow Monitor

8.4 Filtering Views

8.5 LAB: Run and Monitor the Workflow. View Logs and summary load information.

8.6 LAB: Demonstration of Designer Features

 

Debugger

9.1 Debugger Features

9.2 Debugger Windows and Indicators

9.3 Debugger Best Practices

9.4 LAB: Debug a Mapping

 

Transformation

10.1 What is a transformation in Informatica PowerCenter space?

10.2 Active and passive transformation

 

Source Qualifier

11.1 Source Qualifier transformation Overview

11.2 Use of source qualifier to restrict data read from source.

 

Expression Transformation

12.1 Expression Functionality

12.2 Use of a Variable port to hold previous row value.

12.3 Few common expression – IF-ELSE, ISNULL, etc

12.4 LAB: Create a Expression Transformation, Run Workflow

 

Filter Transformation

13.1 Filter Functionality

13.2 Filter Properties

13.3 Filter Versus DB Where Clause

13.4 LAB: Create a Filter Transformation, Run Workflow

 

Sorter Transformation

14.1 Sorter Functionality

14.2 Sorter Properties

14.3 Sorter Versus Database Order by Clause

14.4 LAB: Use Sorter transformation in a mapping

 

Aggregator Transformation

15.1 Aggregator Transformation

15.2 Aggregator Expressions and Functions

15.3 Using Unsorted and Sorted Data

15.4 Data Flow Rules

15.5 Aggregator Versus Database Group By

15.6: LAB : Use aggregator in a mapping.

 

Joiner Transformation

16.1 Homogeneous and Heterogeneous Joins

16.2 Joiner Conditions and Properties

16.3 Joiner Usage

16.4 Types of Joins

16.5 Joiner Versus Database Join

16.6 LAB: Add Sorter, Joiner, and Aggregator

 

Lookup Transformation

17.1 Lookup Principles

17.2 Lookup Properties

17.3 Lookup Caching

17.4 Lookup Versus Database Join

17.5 LAB: Create a Basic Lookup

17.6 Connected Lookup Vs Unconnected Lookup

 

Unconnected Lookups

18.1 Usage and Techniques

18.2 Advantages

18.3 Functionality

18.4 Conditional Lookups

18.5 LAB: Create an Unconnected Lookup

 

Update Strategy Transformation

19.1 Update Strategy Transformation

19.2 Update Strategy Expressions

19.3 Update Strategy Best Practices

19.4 LAB: Create a Type 2 Dimension Update

 

Router Transformation

20.1 Router Functionality

20.2 Router Groups

20.3 LAB: Use a Router to Delete Rows

 

Sequence Generator Transformation

21.1 Sequence Generator Functionality

21.2 Sequence Generator Properties

21.3 Sequence Generator Best Practices

21.4 LAB: Create a Sequence Generator transformation in mapping.

 

Normalizer Transformation

22.1 Normalizer Transformation Functionality

22.2 Theoretical Example of using normalizer in Cobol source.

22.3 LAB: Create a mapping which uses normalizer transformation.

 

Union Transformation

23.1 Overview of Union Transformation

23.2 Union transformation vs database union 

23.3 LAB: Create a mapping which uses union transformation.

 

Parameters and Variables

24.1 Parameter Scoping

24.2 System Variables

24.3 Mapping Parameters and Variables

24.4 Variable Functions

 

Heterogeneous Targets (Theory Only)

25.1 Heterogeneous Target Types

25.2 Target Type Limitations and Conversions

25.3 LAB: Build Heterogeneous Targets

 

Mapplets

26.1 Mapplet Designer

26.2 Mapplet Advantages

26.3 Mapplet Types and Rules

26.4 Active and Passive Mapplets

26.5 Mapplet Parameters  (Excluded Variables)

26.6 Mapplet Designer Best Practices

26.7 LAB: Build a Mapplet

 

Reusable Transformations

27.1 Transformation Developer

27.2 Rules

27.3 Promoting and Copying Transformations

27.4 Transformation Developer Best Practices

27.5 LAB: Create and Use a Reusable Transformation

 

Error Logging

28.1 Setting On and Off

28.2 Data Rejects with Error Logging Off

28.3 Error Logging to Database Table and Flat File

28.4 Source Row Logging

28.5 Error Logging Best Practice Architecture

 

Workflow Configuration

29.1 Server Connections

29.2 Reusable Workflow Schedules

29.3 Reusable Session Configurations

29.4 LAB: Create a Sequential Workflow

29.5 LAB: Create a Concurrent Workflow

 

Reusable Tasks

30.1 The Command Task

30.2 The Email Task

30.3 Reusable Task Best Practices

 

Non-Reusable Tasks

31.1 The Decision Task

31.2 The Assignment Task

31.3 The Timer Task

31.4 The Control Task

31.5 The Event Wait Task

31.6 The Event Raise Task

31.7 Non-Reusable Tasks Best Practices

31.8 LAB: Create Event Wait/Event Raise and Timer

31.9 LAB: Create a Control and Assignment Task

31.10 LAB: Create a Command Line Task

 

Worklets

32.1 Reusable Worklet

32.2 Non-Reusable Worklet

32.3 Worklet Best Practices

 

Advance Topics (Theory)

33.1 Partitioning

33.2 Pushdown techniques

33.3 Optimization

 

 

 

Get trained from the MASTER!!!!! You will not be disappointed.

 

Call me now @267 718 1533

 

Join my course only if you are SERIOUS about learning Informatica

 

This is a course run by a professional for other professionals.