3.95 out of 5
3.95
11 reviews on Udemy

Getting Started with Informatica

Get up and running with Informatica - one of the most sought-after data warehousing tools in the market
Instructor:
Packt Publishing
51 students enrolled
English [Auto-generated]
Get familiar with the admin console
Learn to use the Designer screen
Add transformations using input and output ports
Set up a path and connection
Work with the repository manager screen

This video course 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. Finally, you will learn how to work with the Repository manager screen and thus, make the optimum use of Informatica Power Center!

About the Author :

Rahul Malewar has
been working on various Data Warehousing tools since 10 years majorly
on Informatica Power Center. He has working on various versions of
Informatica Power Center starting version 8.1 to latest 9.x and
Informatica Cloud. He has worked in various MNC’s in India like UST
Global, Cognizant Technologies and Principal Financial services in Pune,
India. He has worked on implementation of some Data Warehouse involving
Informatica for fortune 500 MNC’s like Wellpoint, Principal. He has
experience of working on multiple real time projects in couple of MNC’s
utilizing those skills he has written the book. He is now running his
own training center named Learn Well Technocraft since year 2010 where they provide training on more than 25 Data
warehousing technologies over classroom, corporate and online means. He
has also written a blog on data warehousing concepts. As of today he has
provided training to more than 1700 candidates ranging from fresher’s
to 20 years 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 for which he can be contacted at the address
info@dw-learnwell.com.

Downloading Informatica Power Center 9.x

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.

Installing and Configuring Power Center

1
Installing the Server
This video will help viewers to install Server on machine.
2
Installing the Client
This video will help viewers to install Client on machine.

Getting Familiar with the Admin Console

1
Configuring Domain and Node
This video will teach viewers various aspects of the Administration console including configuring Domain and Nodes.
2
Configuring Repository and Integration Service

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

Setting up Security, Permissions, and Client Configuration

1
Configuring Users and Granting Permissions
This will help viewers to configure users and assign roles and privileges to user.
2
Configuring the Repository Manager
In this video, you will learn to configure a Repository Manager.

Using the Designer Screen

1
Using the Designer Client Interface
This video will teach viewers to understand the graphical interface of Informatica Power Center Designer screen.
2
Working with Sources as Files and Databases
This video helps viewers to import or create various files and databases as Sources.
3
Working with Targets as Files and Databases
This video helps viewers to import or create various files and databases as Targets.

Creating Mappings

1
Creating a New Mapping

This video helps viewers to create the mappings.

2
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.

Getting Acquainted with the Workflow Manager Screen

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

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

Setting Up a Path and Connection

1
Setting the Source And Target Paths
This will help viewers to set up the connection and path for the workflow execution.
2
Executing the Workflow
This will help viewers to execute the workflow or execute an individual task.

Getting Accustomed to the Workflow Monitor Screen

1
The Workflow Monitor
This video will help viewers to understand the Workflow Monitor Screen.
2
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.

Working with the Repository Manager Screen

1
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

2
The Export-Import Feature

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

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
4 out of 5
11 Ratings

Detailed Rating

Stars 5
5
Stars 4
1
Stars 3
3
Stars 2
2
Stars 1
0
0bcf2a03974c74efcf4ec1de1e04b0fa
30-Day Money-Back Guarantee

Includes

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