Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Mastering Informatica PowerCenter 9
Rating: 3.8 out of 5(38 ratings)
267 students

Mastering Informatica PowerCenter 9

Master the advanced aspects of the Informatica client to create reusable transformations and mapplets
Last updated 9/2017
English

What you'll learn

  • Work on parameter files and gain an insight to the scheduling workflow
  • Find out how to debug and identify issues in mappings
  • Work with the target load plan
  • Configure the internal scheduler and file lists
  • Work with incremental aggregation
  • Get equipped to handle different types of partitions

Course content

6 sections27 lectures1h 43m total length
  • The Course Overview2:44

    This video will give an overview of the entire course.

  • Creating Reusable Transformations3:56

    Let’s take a look at the working and usage of the Reusable Transformations in this video.

  • Creating Mapplets2:20

    We will familiarize ourselves with the working and usage of the Mapplets

  • Working With Debugger6:18
    The aim of this video is to get to know the working and usage of the Debugger

Requirements

  • This course will give you basic to intermediate skills in Informatica, and will help you to prepare for the global certification in Informatica.

Description

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.

Who this course is for:

  • This video will address the steps required for installing Informatica Power Center. It will take viewers through a step-by-step approach to download and install the Informatica Power Center Server and Client. We will also take a look at various aspects of the Admin Console, such as the Repository, Domain, Node, Integration Service etc.