3.3 out of 5
3.3
19 reviews on Udemy

Mastering Informatica PowerCenter 9

Master the advanced aspects of the Informatica client to create reusable transformations and mapplets
Instructor:
Packt Publishing
155 students enrolled
English [Auto-generated]
Work on parameter files and gain an insight to the scheduling workflow
Find out how to debug and identify issues in mappings
Work with the target load plan
Configure the internal scheduler and file lists
Work with incremental aggregation
Get equipped to handle different types of partitions

Informatica is a leader in the ETL market and provides lot of job opportunities in the industry. This course will give you basic to intermediate skills in Informatica, and will help you to prepare for the global certification in Informatica.
You’ll start the course by learning to debug a mapping, which will help you identify any issues in mappings. You’ll be introduced to the advanced aspects of the Designer and Workflow Manager screens. Then you’ll find out how to create reusable transformations and mapplets. Then, we move on to working with the target load plan and you’ll learn to compare objects.
The latter part of the course is centered around using the Workflow Manager screen. You’ll learn about the various tasks that are present in Informatica along with the scheduling workflow. We’ll also take a look at various aspects of the Admin Console, such as the Repository, Domain, Node, Integration Service, and more. Finally, we’ll conclude the course with incremental aggregation, configuring file lists, and working with various types of partitions.

About the Author

Rahul Malewar has been working on various Data Warehousing tools for 10 years, mostly on Informatica Power Center. He has worked on various versions of Informatica Power Center starting at version 8.1 up to the latest version 9.x and Informatica Cloud. He has worked for various MNCs in India such as UST Global, Cognizant Technologies, and Principal Financial services in Pune.
He has worked on the implementation of some Data Warehouses involving Informatica for fortune 500 MNCs such as Wellpoint and Principal. He has experience of working on multiple real-time projects in MNCs. He has run his own training center named Learn Well Technocraft since 2010, which provides training on more than 25 Data Warehousing technologies via classroom, corporate, and online. He has also written a blog on data warehousing concepts.
As of today, he has provided training to more than 1200 candidates ranging from freshers to 20-year experienced professionals. He is also a Director of a software firm named Gut Lernen Technocraft Pvt. Ltd., where they work on data warehousing and mobile-related projects.

Reusable Transformations, Mapplets, and Debugger

1
The Course Overview

This video will give an overview of the entire course.

2
Creating Reusable Transformations

Let’s take a look at the working and usage of the Reusable Transformations in this video.

3
Creating Mapplets

We will familiarize ourselves with the working and usage of the Mapplets

4
Working With Debugger
The aim of this video is to get to know the working and usage of the Debugger

Learning Advanced Aspects

1
Target Loan Plan

The goal of this video is to get an in-depth understanding of the working and usage of the Target Loan Plan

2
Comparing Objects
The goal of this video is to get an in-depth understanding of the working and usage of the Comparing Objects
3
Dependencies
In this video we will look at the working and usage of the Dependencies
4
Tracing Level
We will familiarize ourselves with the working and usage of the Tracing Level

Working With Tasks

1
Types Of Tasks
Before we move ahead with the implementation of the task in Informatica Power Center
2
Command task

In this video we will look at the working and usage of the Command task

3
Email Task
The goal of this video is to get an in-depth understanding of the working and usage of the Email Task
4
Event Task

We will familiarize ourselves with the working and usage of the Event Task

5
Timer Task

Let’s take a look at the working and usage of the Timer Task in this video.

Working With Other Tasks

1
Link Task

The goal of this video is to get an in-depth understanding of the working and usage of the Link Task

2
Decision Task

Let’s take a look at the working and usage of the Decision Task in this video.

3
Assignment Task
We will familiarize ourselves with the working and usage of the Assignment Task
4
Control Task

In this video we will look at the working and usage of the Control Task

5
Session Task Properties

Let’s take a look at the working and usage of the Session Task in this video.

Advanced Utilities Of Workflow Manager

1
Configuring internal Scheduler

In this video we will look at the working and usage of the Scheduler

2
Reusable Tasks

The goal of this video is to get an in-depth understanding of the working and usage of the Reusable tasks

3
Worklets

We will familiarize ourselves with the working and usage of the Worklets

4
Configuring File Lists
Our aim is to understand File Lists
5
Working with Incremental Aggregation

Let’s take a look at the working and usage of the Incremental Aggregation in this video.

6
Working on Parameter Files

In this video we will look at the working and usage of the Parameter Files

Performance Optimization, Pushdown optimization, Partitioning

1
Performance Optimization

The goal of this video is to understand working and usage of the Performance Optimization

2
Partitioning
In this video we will look at the working and usage of the Partitioning
3
Pushdown Optimization

We will familiarize ourselves with the working and usage of the Pushdown Optimization

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
3.3
3.3 out of 5
19 Ratings

Detailed Rating

Stars 5
5
Stars 4
6
Stars 3
5
Stars 2
2
Stars 1
1
b60509ab3f1176f897dd08a4cee74001
30-Day Money-Back Guarantee

Includes

2 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion