Video 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.
What You Will 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
Audience
This course will help technical and non-technical people who want to make their career using one of the most sought after Data Warehousing tools in the market. 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.
About The Author
Rahul Malewar: Rahul Malewar has been working on various Data Warehousing tools for 10 years, primarily on Informatica Power Center. He has worked on various versions of Informatica Power Center, from version 8.1 to the latest version, 9.x, and Informatica Cloud. He has worked in various MNC's in India such as UST Global, Cognizant Technologies, and Principal Financial services in Pune, India. He has worked on the implementation of some Data Warehouses involving Informatica for fortune 500 MNC's such as Wellpoint, Principal. He has experience in working on multiple real-time projects in a couple of MNC's; utilizing those skills, he has written the book. He has now been running his own training center named Learn Well Technocraft (www.dw-learnwell.com) since 2010; here, he provides training on more than 25 Data warehousing technologies via classroom, corporate, and online means. He has also written a blog on data warehousing concepts. As of today, he has provided training to more than 1,200 candidates ranging from freshers to professionals with 20 years' experience. 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. He provides free assistance on Informatica installation-related topics and other technical issues; he can be contacted at info@dw-learnwell.com.
Table of contents
Product information
- Title: Mastering Informatica PowerCenter 9
- Author(s):
- Release date: August 2017
- Publisher(s): Packt Publishing
- ISBN: 9781787127852
You might also like
book
Learning Informatica PowerCenter 9.x
Learn the art of extracting data from disparate systems, integrating it using the leading data integration …
video
Getting Started with Informatica
This video course will kick-start with taking you through downloading Informatica Power Center and extracting it. …
book
Learning Informatica PowerCenter 10.x - Second Edition
Harness the power and simplicity of Informatica PowerCenter 10.x to build and manage efficient data management …
book
OCA Oracle Database SQL Exam Guide (Exam 1Z0-071)
A fully updated, integrated self-study system for the Oracle Database SQL Exam This thoroughly revised Oracle …