Informatica PowerCenter - Beginner to Expert Level

Informatica PowerCenter - Beginner to Expert Level

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

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

Url: View Details

What you will learn

• Learn ETL best practices using Informatica
• Learn debugging, troubleshooting and error handling using informatica
• Learn Data Warehouse Concepts and ETL Concepts

Rating: 4.44186

Level: All Levels

Duration: 19.5 hours

Instructor: Smart Coders Hub