Video description
Get up and running with Informatica - one of the most sought-after data warehousing tools in the market
About This Video
Install and configure Informatica Power Center
Get acquainted with the workflow manager screen
Set up security, permissions, and client configuration with this practical guide
In Detail
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!
Audience
This course is aimed at technical and non-technical people who aim to make their career using one of the most sought after Data Warehousing tools in the market. Informatica is a leader in the ETL market and provides lot of job opportunities in the industry. This course will equip people with the basic to intermediate levels of Informatica, and will help them to prepare for the global certification of Informatica.
Table of Contents
Chapter 1 : Downloading Informatica Power Center 9.x
The Course Overview
Downloading the Tool
Extracting the Tool from Its .zip File
Chapter 2 : Installing and Configuring Power Center
Installing the Server
Installing the Client
Chapter 3 : Getting Familiar with the Admin Console
Configuring Domain and Node
Configuring Repository and Integration Service
Chapter 4 : Setting up Security, Permissions, and Client Configuration
Configuring Users and Granting Permissions
Configuring the Repository Manager
Chapter 5 : Using the Designer screen
Using the Designer Client Interface
Working with Sources as Files and Databases
Working with Targets as Files and Databases
Chapter 6 : Creating Mappings
Creating a New Mapping
Adding Transformation Using Input and Output Ports
Chapter 7 : Getting Acquainted with the Workflow Manager Screen
Using the Workflow Manager Interface
Using the Workflow Manager
Chapter 8 : Setting Up a Path and Connection
Setting the Source And Target Paths
Executing the Workflow
Chapter 9 : Getting Accustomed to the Workflow Monitor Screen
The Workflow Monitor
The Workflow Log, Session Log, And Run Properties
Chapter 10 : Working with the Repository Manager Screen
Copy-Paste and Drag-Drop Features
The Export-Import Feature