Mastering Informatica PowerCenter 9
Informatica is a leader in the ETL market and provides lot of job opportunities in the industry. This course will give you basic to intermediate skills in Informatica, and will help you to prepare for the global certification in Informatica.
You’ll start the course by learning to debug a mapping, which will help you identify any issues in mappings. You’ll be introduced to the advanced aspects of the Designer and Workflow Manager screens. Then you’ll find out how to create reusable transformations and mapplets. Then, we move on to working with the target load plan and you’ll learn to compare objects.
The latter part of the course is centered around using the Workflow Manager screen. You’ll learn about the various tasks that are present in Informatica along with the scheduling workflow. We’ll also take a look at various aspects of the Admin Console, such as the Repository, Domain, Node, Integration Service, and more. Finally, we’ll conclude the course with incremental aggregation, configuring file lists, and working with various types of partitions.
About the Author
Rahul Malewar has been working on various Data Warehousing tools for 10 years, mostly on Informatica Power Center. He has worked on various versions of Informatica Power Center starting at version 8.1 up to the latest version 9.x and Informatica Cloud. He has worked for various MNCs in India such as UST Global, Cognizant Technologies, and Principal Financial services in Pune.
He has worked on the implementation of some Data Warehouses involving Informatica for fortune 500 MNCs such as Wellpoint and Principal. He has experience of working on multiple real-time projects in MNCs. He has run his own training center named Learn Well Technocraft since 2010, which provides training on more than 25 Data Warehousing technologies via classroom, corporate, and online. He has also written a blog on data warehousing concepts.
As of today, he has provided training to more than 1200 candidates ranging from freshers to 20-year experienced professionals. He is also a Director of a software firm named Gut Lernen Technocraft Pvt. Ltd., where they work on data warehousing and mobile-related projects.
Reusable Transformations, Mapplets, and Debugger
This video will give an overview of the entire course.
Let’s take a look at the working and usage of the Reusable Transformations in this video.
We will familiarize ourselves with the working and usage of the Mapplets
Learning Advanced Aspects
The goal of this video is to get an in-depth understanding of the working and usage of the Target Loan Plan
Working With Tasks
In this video we will look at the working and usage of the Command task
We will familiarize ourselves with the working and usage of the Event Task
Let’s take a look at the working and usage of the Timer Task in this video.
Working With Other Tasks
The goal of this video is to get an in-depth understanding of the working and usage of the Link Task
Let’s take a look at the working and usage of the Decision Task in this video.
In this video we will look at the working and usage of the Control Task
Let’s take a look at the working and usage of the Session Task in this video.
Advanced Utilities Of Workflow Manager
In this video we will look at the working and usage of the Scheduler
The goal of this video is to get an in-depth understanding of the working and usage of the Reusable tasks
We will familiarize ourselves with the working and usage of the Worklets
Let’s take a look at the working and usage of the Incremental Aggregation in this video.
In this video we will look at the working and usage of the Parameter Files
Performance Optimization, Pushdown optimization, Partitioning
The goal of this video is to understand working and usage of the Performance Optimization
We will familiarize ourselves with the working and usage of the Pushdown Optimization
