Informatica Power Center Training In USA!!!

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

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

General information about the course

Next batch starts on

• 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

Swathi is an expert in Informatica PowerCenter space, whether as a developer or administrator role. She is well experienced in mapping for very complex ETL logic using almost every transformation. She is comfortable in almost every corner of PowerCenter -- mapplet, reusable transformation, session and various other tasks, work lets, workflow, optimization, error handling, re-runnablity of workflow, installing of power center server/client, creating domain/repository/integration service/web service, restore/backup of repository and much more. Overall, she is having 5+ years of IT experience in Oracle 9i/10g, MySQL, Informatica PowerCenter 7.1.3/8.6/9.1.
(DW/BI,Oracle,Database,Oracle DBA,SQL & Related,Oracle OLAP)

Contact Information

Daniel AG-Founder + Master DBA
Empire Data Systems LLC- #1 Database Training House in USA!!!

"Get trained from the MASTER!!!"

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 extression – 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

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 and 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

Join my course only if you are SERIOUS about learning Informatica

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