Informatica PowerCenter - Beginner to Expert Level
- 4.4
Brief Introduction
Master the skills needed for Informatica development, architecture and various transformationsDescription
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
Requirements
- Basic computer and Database knowledge is required
- Knowledge of SQL will be helpful
- Passion to learn about Informatica is must