What Will I Learn?

Learn how to understand Data Warehouse Concepts and ETL Concepts
Learn all the Informatica PowerCenter architecture and its different components
Workflow task and Job handlings
Mapping parameter and variables
Identify the functionalities of the Repository Manager tool
Learn how to execute performance tuning and Optimization

Requirements

Basic Knowledge on SQL
Basic Knowledge on UNIX commands

+ View More

Description

Informatica is one of the best tool for Data Integration. In this course, you will be learning Extraction, Transformation and Load process/life cycles.

Informatica Powercenter is an easy to use GUI based tool in which we use simple drag and drop feature for different objects like

Sources and targets
Transformations
Mapplets
Mappings
Sessions
Worklets
Workflows

The objects are integrated into the packages called workflow. This course covers you the following concepts such as

Data Warehousing concepts
Dimensional Modelling
ETL designs
Filter Transformations
Router Transformations
Sorter Transformations
Aggregator Transformations
Joiner Transformations
Source Qualifier Transformations
Lookup Transformations
Update Strategy Transformations
Transaction Control Transformations

and much more!

Curriculum For This Course

38 Lessons 37 Hours

Introduction & Getting started

38 Lessons 12:33:37 Hours

Data warehousing Basics 01:09:30 Preview
Dimentional Modelling Facts Types of Dimensions 01:28:44 Preview
ETL Design OLTP OLAP Staging Schema 01:10:36
Designer-workflow monitor - repository manager 00:47:36
Transformations - Expressions - Mapplets 01:15:32
Expressions - Encryption - Cross Linking 00:58:59
Filter Transformation 00:43:22
Router Transformation 00:56:50
Sorter Transformation 00:57:05
Practicals - Database Connections 01:12:01
Aggregator Transformation 01:05:55
Joiner Transformation 01:14:11
Source Qualifier Transformation 01:18:58
Source Qualifier - pre and post sql 00:48:01
Lookup transformation 01:00:48
Lookup Transformation Static and Dynamic 01:02:44
Normalizer - Flat File 00:51:45
Sequence Generator 00:53:35
Update Strategy Transformation 00:53:24
Transaction Control Transformation 00:55:04
XML - Source to Target Incremental Load 00:56:54
Stored Procedure - Connected - Unconnected 00:52:25
Stored Procedure - Pre and post Load 00:33:52
Batch Processing - Interview Discussion 00:50:14
Batch Processing - Timer Task 01:09:14
WorkFlow and Mapplets 00:50:05
Update Operations - Mapping and Session level 00:13:23
Update Operation without Update Strategy 00:46:07
Update Strategy - Update else Insert 00:55:46
Incremental Loading 01:04:28
Slowly Changing Dimension - with Lookup 01:08:07
Slowley Changing Dimension without Lookup 00:12:50
Handling huge Data - Lookups and Indexes 01:18:32
Slowly Changing Dimension 2 01:09:52
Dynamic Lookup 01:03:12
Data Driven Aggregation 01:10:07
Incremental Aggregation 00:20:55
Incremental Aggregation - Aggregator Cache 01:12:54

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

Informatica PowerCenter Traini...

Prerana Krishna

$ 149.99$ 14.99

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 36 Hours Tutorial