Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

Informatica PowerCenter - Beginner to Expert Level

via Udemy

Overview

Master the skills needed for Informatica development, architecture and various transformations

What you'll learn:
  • Learn ETL best practices using Informatica
  • Learn debugging, troubleshooting and error handling using informatica
  • Learn Data Warehouse Concepts and ETL Concepts
  • Learn Mapping Parameter and Variables
  • Understand Informatica PowerCenter architecture & its different components
  • Learn to build Mappings, Tasks, Workflows

Informatica is a widely used ETL tool which is used to extract the raw data and load it into the target data after making some transformations. ETL stands for Extract Transform Load which refers to the processes performed when transforming raw data to a data warehouse or data mart or relational databases. Informatica is an easy to use tool and it also has a simple visual interface like forms. Through this training, you shall be equipped with skills needed for Informatica development, architecture and various transformations. Through this training, you shall be equipped with advanced skills needed for Informatica development, architecture and various transformations. Informatica is the leader of ETL. 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. Informatica Power Center is an easy to use GUI based tool. Components are used by a simple drag and drop features for objects like source, mappings, worklets etc. The training will cover the followings:

Introduction Informatica Powercenter 9.6.1

Getting Started

Power Center Designer

Download and Install Informatica

Client and Server Installation

Example Solved

RouterTransformation

Filter Transformation

Router Transformation

Aggregator Transformation

Joiner Transformation

Demo

Rank Transformation

Lookup Transformation

Analyzing the Designer Pattern

Creating a Workflow

Use Router Transformation

Expression Transformation

Mapplet

Taught by

Smart Coders Hub

Related Courses

Reviews

Start your review of Informatica PowerCenter - Beginner to Expert Level

Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free