4.3 out of 5
4.3
304 reviews on Udemy

LEARNING PATH: Complete Roadway to Informatica Powercenter 9

Sharpen your data warehousing skills by mastering the techniques of Informatica PowerCenter
Instructor:
Packt Publishing
1,217 students enrolled
English [Auto-generated]
Get familiar with the admin console
Add transformations using input and output ports
Work with the repository manager screen
Classify active, passive, connected, and unconnected transformations
Work on parameter files and gain an insight to the scheduling workflow
Find out how to debug and identify issues in mappings
Configure the internal scheduler and file lists
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. The components within Informatica PowerCenter aid in extracting data from its source, transforming it as per business requirements and loading it into a target data warehouse. The main components of Informatica PowerCenter are its client tools, server, repository server and repository. The PowerCenter server and repository server make up the ETL layer, which completes the ETL processing.  If you’re interested to work with various transformations and implement different types of SCDs in PowerCenter 9 to create reusable transformations and mapplets, then go for this Learning Path.

Packt’s Video Learning Paths are a series of individual video products put together in a logical and stepwise manner such that each video builds on the skills learned in the video before it.

The highlights of this Learning Path are:

  • Learn to use the designer screen
  • Use advanced transformations such as Rank and Joiner to classify active, passive, connected, and unconnected transformations
  • Implement SCD1, SCD2, and SCD3 mappings

This Learning Path will kick-start with taking you through downloading Informatica Power Center and extracting it. It will help you to gain a deeper insight at various aspects of the Informatica administrator console, such as domains, node, repository and integration service. You will then learn to import and create a source and target, and move on to creating mappings and using transformations ports. Next, the course will walk you through the Workflow Manager Screen and skill you to set up a path and connection. You will also learn how to work with the repository manager screen and thus, make the optimum use of Informatica Power Center!

Further, you will learn how to use transformations such as aggregator and filter, after which you will move onto more advanced transformations such as Joiner, Union, and Rank. You will also learn 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. Finally, 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.

By the end of this Learning Path, you will be able to work with various transformations and implement different types of SCDs to master the advanced aspects of the Informatica client to create reusable transformations and mapplets.

Meet Your Experts:

We have combined the best works of the following esteemed author to ensure that your learning journey is smooth:

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. He provides free assistance on Informatica installation related and other technical issues.

Getting Started with Informatica

1
The Course Overview

This video provides an overview of the entire course.

2
Downloading the Tool

This video will help viewers to download the Informatica Power Center 9.x tool.

3
Extracting the Tool from Its .zip File

This video will help viewers to extract the downloaded files for installation.

4
Installing the Server

This video will help viewers to install Server on machine.

5
Installing the Client

This video will help viewers to install Client on machine. 

6
Configuring Domain and Node

This video will teach viewers various aspects of the Administration console including configuring Domain and Nodes.

7
Configuring Repository and Integration Service

This will help viewers to create Repository and Integration Service in Admin console.

8
Configuring Users and Granting Permissions

This will help viewers to configure users and assign roles and privileges to user. 

9
Configuring the Repository Manager

In this video, you will learn to configure a Repository Manager.

10
Using the Designer Client Interface

This video will teach viewers to understand the graphical interface of Informatica Power Center Designer screen.

11
Working with Sources as Files and Databases

This video helps viewers to import or create various files and databases as Sources.

12
Working with Targets as Files and Databases

This video helps viewers to import or create various files and databases as Targets.

13
Creating a New Mapping

This video helps viewers to create the mappings.

14
Adding Transformation Using Input and Output Ports

This video will teach viewers to use Transformations in Mapping and use input and output ports in mapping.

15
Using the Workflow Manager Interface

This video will teach viewers to work on basic aspects of the Workflow Manager screen.

16
Using the Workflow Manager

This video will teach the viewers to create workflows, add tasks in a workflow and connect them with links.

17
Setting the Source And Target Paths

This will help viewers to set up the connection and path for the workflow execution. 

18
Executing the Workflow

This will help viewers to execute the workflow or execute an individual task.

19
The Workflow Monitor

This video will help viewers to understand the Workflow Monitor Screen.

20
The Workflow Log, Session Log, And Run Properties

In this video, we will learn to check the Workflow and Session log. Also, we will learn to check the Runtime properties.

21
Copy-Paste and Drag-Drop Features

In this video we talk about the 4th Client tool, Repository Manager, which helps us to do the migration using the copy-paste and drag-drop features.

22
The Export-Import Feature

In this video, we will learn to do migration using the export-import feature.

23
Getting Started with Informatica

Implementing Informatica PowerCenter 9

1
The Course Overview

This video gives an overview of the entire course.

2
The Expression Transformation

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

3
The Aggregator Transformation

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

4
The Sorter Transformation

We will familiarize ourselves with the working and usage of the sorter transformation

5
The Filter Transformation

The aim of this video is to get to know the working and usage of the filter transformation

6
The Router Transformation

Let's take a look at the working and usage of the router transformation in this video.

7
The Rank Transformation

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

8
The Joiner Transformation

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

9
The Union Transformation

We will familiarize ourselves with the working and usage of the union transformation

10
The Source Qualifier Transformation

The aim of this video is to get to know the working and usage of the source qualifier transformation

11
The Sequence Generator Transformation

Let's take a look at the working and usage of the sequence generator in this video.

12
Classification of Transformation

Our aim would be to classify transformations before learning about more advanced transformations.

13
The Lookup Transformation

In this video we will implement a mapping similar to the one shown in the Joiner transformation using the Lookup transformation

14
Types of Caches

This video is an in-depth look at the caches available.

15
The Update Strategy Transformation

We will familiarize ourselves with the working and usage of the update strategy transformation

16
The Stored Procedure Transformation

The goal of this video is to get an in-depth understanding of the working and usage of the stored procedure transformation

17
Understanding SCD Types

Before we move ahead with the implementation of the SCD in Informatica Power Center, let's discuss the different types of SCDs in this video

18
Implementing SCD1 Mapping

We will look at implementing SCD1 mapping

19
Implementing SCD2 Mapping

Our goal is to implement SCD2 mapping

20
Implementing SCD3 Mapping

Our aim is to understand SCD3 mapping

21
Implementing Informatica PowerCenter 9

Mastering Informatica PowerCenter 9

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

5
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

6
Comparing Objects

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

7
Dependencies

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

8
Tracing Level

We will familiarize ourselves with the working and usage of the Tracing Level

9
Types Of Tasks

Before we move ahead with the implementation of the task in Informatica Power Center

10
Command task

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

11
Email Task

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

12
Event Task

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

13
Timer Task

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

14
Link Task

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

15
Decision Task

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

16
Assignment Task

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

17
Control Task

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

18
Session Task Properties

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

19
Configuring internal Scheduler

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

20
Reusable Tasks

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

21
Worklets

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

22
Configuring File Lists

Our aim is to understand File Lists

23
Working with Incremental Aggregation

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

24
Working on Parameter Files

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

25
Performance Optimization

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

26
Partitioning

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

27
Pushdown Optimization

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

28
Mastering Informatica PowerCenter 9
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!
4.3
4.3 out of 5
304 Ratings

Detailed Rating

Stars 5
121
Stars 4
124
Stars 3
39
Stars 2
11
Stars 1
10
0f054eaf26edbfc9d31c0d4d8606cad3
30-Day Money-Back Guarantee

Includes

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