Informatica PowerCenter Training

What Will I Learn?

Understand Data Warehouse Concepts and ETL Concepts
Use PowerCenter 9.x components to build Mappings, Tasks, Workflows
Understand Workflow Task and job handling
Describe Informatica PowerCenter architecture & its different components
Describe the basic and advanced features functionalities of PowerCenter 9.6 transformations
Gain insight on ETL best practices using Informatica
Crack the Informatica Interviews
Understand all the basic interview questions for all the transformations and real time scenarios
Understand Data Warehouse Concepts and ETL Concepts
Use PowerCenter 9.x components to build Mappings, Tasks, Workflows
Understand Workflow Task and job handling
Describe Informatica PowerCenter architecture & its different components
Describe the basic and advanced features functionalities of PowerCenter 9.6 transformations
Gain insight on ETL best practices using Informatica
Crack the Informatica Interviews

Requirements

Basic SQL knowledge is required
Laptop or Desktop with Internet connection

+ View More

Description

Informatica is a widely used ETL tool which is used to extract the raw data and load it to target data after making some transformations. ETL means "Extract Transform Load" which refers to the processes performed when transforming raw data to a data warehouse or relational databases.

Informatica is a user-friendly tool which has simple visual interface forms. At the end of this training, you will be skilled to Informatica Development, Architecture and various transformations. And also you will be highly equipped with advanced skills needed for Informatica development.

The main components of Informatica PowerCenter are its Client tools, Server, Repository Server and Repository. The PowerCenter Server and repository server makes up the ETL layer, which completes the ETL processing.

As this tool is easy to use tool, you simply drag and drop the objects like source, mappings, worklets, etc.

Curriculum For This Course

153 Lessons 20 Hours

Informatica PowerCenter 9.6.1 Beginners - Introduction

1 Lessons 00:06:45 Hours

Introduction to Informatica 00:06:45 Preview

Getting Started

5 Lessons 00:38:26 Hours

Informatica Dataware Housing 00:09:35 Preview
Data Mart in Informatica 00:07:02
ETL Diagram 00:08:51
Example of ETL 00:06:13
More on Informatica 00:06:45

PowerCenter Designer

5 Lessons 00:15:18 Hours

PowerCenter Designer in Informatica 00:03:45
PowerCenter Workflow 00:03:48
PowerCenter Monitor 00:02:31
PowerCenter Repository 00:03:21
Overview of Informatica 00:01:53

Download and Install Informatica

9 Lessons 00:43:58 Hours

Download Java in Informatica 00:03:44
Installation of Java File in Informatica 00:02:45
Downloading Orcale For Informatica Server 00:04:28
Downloading Sql Developer For Informatica Server 00:04:51
Installation of SQL Developer 00:06:51
Creating a Connection Between Sql Developer and Java 00:06:02
Download and Install Informatica 00:05:18
Installation of Informatica 00:03:16
Installation of Informatica Continue 00:06:43

Client and Server Installation

4 Lessons 00:26:59 Hours

Pre Installation of Informatica Server 00:08:21
Server Installation of Informatica Server 00:04:57
Server Installation of Informatica Server Continues 00:06:00
Informatica Server Client Installation 00:07:41

Example Solved

13 Lessons 01:42:41 Hours

Loading Data to Target 00:09:37
Customer Table Demo 00:07:51
Developing Mapping 00:09:00
Transform Apply Logic 00:10:55
Creating WorkFlow 00:10:27
Loading Data by Transformation 00:08:12
Creating Customer Details 00:07:42
Creating Mapping 00:07:01
Working with Function Concat 00:08:43
Applying Transformation Logic 00:07:31
Checking Valid Mapping 00:05:20
Concatinating Names 00:08:18
Overview in Expression Transformation 00:02:04

Router Transformation

7 Lessons 00:56:55 Hours

Concept of Router Transformation 00:04:45
Using Router Transformation 00:09:33
Applying Expression Transformation 00:06:45
Router Transformation Demo 00:05:02
Grouping in Router Transformation 00:12:03
Creating Work Flows 00:09:48
Analyzing in SQL Developer 00:08:59

Filter Transformation

5 Lessons 00:30:35 Hours

Concept of Filter Transformation 00:09:01
Comparing Router and Filter Transformation 00:04:45
Loading Data in Target Table 00:07:14
Validating Filter Properties 00:04:34
Filter Transformation Demo 00:05:01

Router Transformation

7 Lessons 00:55:51 Hours

Tutuorials on Router Transformation 00:03:08
Comparison between Router and Filter 00:08:27
Source and Source Qualifier 00:07:15
Different Target Tables 00:11:21
Loading Data for Target Tables 00:08:53
Advantages of Router Transformation 00:08:25
Advantages of Router Transformation Continues 00:08:22

Aggregator Transformation

7 Lessons 00:57:07 Hours

Understanding Aggregator Transformation 00:07:19
Scenario for Aggregator Transformation 00:10:01
Functions for Aggregator Transformation 00:08:51
Editing in Aggregator Transformation 00:09:22
Working in Target Table 00:08:50
Data from the Source File 00:08:33
Truncating the Table 00:04:11

Joiner Transformation

7 Lessons 00:55:55 Hours

Understanding the Joiner Transformation 00:05:56
Different types of Joins 00:07:19
Functions of Master Outerjoin 00:07:36
Generating and Executing SQL 00:09:13
Mapping the Codes for Targets 00:07:52
Understanding Details Outer Join 00:09:23
Workflow from Designer Window 00:08:36

Demo

7 Lessons 00:51:58 Hours

Learning Full Outerjoin 00:10:12
Truncate Target Table Option 00:05:48
Defining the Normal Join 00:09:41
Checking the Connection Details 00:06:43
Performing Normal Join on Example 00:09:23
Creating a New Target Table 00:06:39
Executing the Workflow for Normal Join 00:03:32

Rank Transformation

6 Lessons 00:55:52 Hours

Concept of Rank Transformation 00:11:22
Practical Example on Rank Transformation 00:08:24
Defining Rank Properties 00:09:57
Designing the Transformation Attributes 00:05:27
Understanding the Sequence Transformation 00:09:46
Creating Table and Loading Data 00:10:56

Lookup Transformation

12 Lessons 01:50:05 Hours

Understanding Lookup Transformation 00:09:37
Example on Lookup Transformation 00:09:23
Cashed or Uncashed Lookup 00:08:37
Learning Unconnected Lookup 00:10:21
Demo for Connected and Unconnected Lookup 00:06:27
Data Type of Different Lookups 00:11:15
Creating the Workflow 00:08:34
Initializing in Workflow 00:07:47
Example on Unconnected Lookup 00:08:43
Unconnected Lookup Mapping 00:10:29
Unconnected Lookup Mapping Continues 00:09:41
Different Lookups in Mapping 00:09:11

Informatica PowerCenter 9.6.1 Advanced - Introduction

58 Lessons 07:47:13 Hours

Introduction to Informatica Powercentre Advanced 00:08:09
Union Transformation box 00:07:54
Analyzing the Designer Pattern 00:08:32
Creating a Workflow 00:07:52
Check in the Objects 00:07:02
Checkout and Editing 00:07:02
Comparing Objects and Export 00:08:37
Introduction to Normalization Transformation 00:11:58
CID and GK Value 00:08:04
Student Score 00:09:10
Workflow Normalizer 00:09:04
Sequel Developer 00:07:44
Mapping Designer 00:06:15
What is Normalisation Transformation 00:07:15
Sales Demo 00:09:06
Normalizer Import Export 00:08:00
Introduction to Update Strategy Tranformation 00:11:21
Options 00:06:11
What is the Scenario 00:10:32
Workflow 00:07:40
Update the Record 00:12:09
Source file Directory 00:08:32
Stored Procedure Transformation 00:10:18
Connected Stored Procedure Transformation 00:08:01
Source Table 00:06:22
Target Table 00:06:54
Dollar Target 00:09:16
Unconnected Stored Procedure Transformation 00:09:37
Unconnected Transformation Method 00:08:00
Introduction to Slowly Changing Dimensions 00:10:02
SCD Type 00:10:08
Select Department Table 00:09:27
Department Table Continue 00:07:14
Updated Record 00:09:20
Department Current Data 00:07:14
Conclusion SCD 00:04:08
Slowly Changing Dimension Type 2 00:07:00
Slowly Changing Dimension Type 2 Continue 00:07:00
Generate Execute SQL 00:09:05
Updated Location 00:11:25
Max of Version 00:03:16
Use Router Transformation 00:08:27
Used to Filter Transformation 00:07:19
SRC Table 00:06:27
Intoduction to Flag 00:08:07
Flagging Demo 00:08:32
Sequence Generator Transformation 00:10:22
Passing the Serial Number 00:08:40
SRC Flag Values 00:06:04
Active Records 00:05:42
Slowly Changing Dimension Type 3 00:09:12
Expression Transformation 00:09:08
New records and Updated Records 00:06:39
New records and Updated Records Continue 00:05:47
Introduction to Mapplet 00:07:20
Mapplet Input and Mapplet Output 00:07:26
Employee Commission Data 00:04:39
Parameter Variable 00:05:26

Related Courses

Linux command line tutorial - ...

Renjith Nair

Free

Master Python 3 Programming

ramya

$ 200$ 9.99

Master Golang Programming

ramya

$ 200$ 14.99

Master Ethical Hacking

Spark Databox

$ 200$ 9.99

Adobe Photoshop Lightroom Clas...

ramya

$ 54$ 20

Complete Android app developme...

Spark Databox

$ 200$ 9.99

Python Complete reference : Go...

Prabhu Y

$ 94.99$ 13

SDN Practical Hands On Trainin...

Prabhu Y

$ 99$ 9.99

Data Structures & Algorithms i...

Deepika S

$ 129.99$ 9.99

Docker for DevOps

Michael John

$ 149.99$ 12.99

Data Science with Python

Harish Gowda

$ 199.99$ 11.99

The Container, Kubernetes and ...

Sam Johnson

$ 199.99$ 14.99

UiPath Handson on Enterprise R...

Michael Jordan

$ 199.99$ 47

Mulesoft ESB Training

Kenny James

$ 119.99$ 9.99

Master Devops Online Training

Ajay Prabhakar

$ 94.99$ 8.99

Linux System Programming - A p...

Mohan Parasuram

$ 49.99$ 11.99

Informatica PowerCenter Training