Discount FREE 100% Off
Informatica PowerCenter - Beginner to Expert Level
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 to build Mappings, Tasks, Workflows
- Understand Informatica PowerCenter architecture & its different components
- Learn Data Warehouse Concepts and ETL Concepts
- Learn Mapping Parameter and Variables
Requirements and What you should know?
- Knowledge of SQL will be helpful
- Passion to learn about Informatica is must
- Basic computer and Database knowledge is required
Who is this course for?
- ETL or Data warehouse professionals
- Mainframe developers and architects
- Graduates who wanted to enter IT field
- Analytics professionals
- Software developers
What is this course about?
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
